"UTF-8"编解码器无法解码位置 121 中的字节0xa0：起始字节无效

Question

如何解决这个问题?谢谢你。

from google.colab import drive
drive.mount('/content/drive')
path = "/content/drive/MyDrive/Colab Notebooks/Meteo.csv"
Meteo = pd.read_csv(path, parse_dates=[['Date', 'Time']])
Meteo.head()

CSV样本

我正在寻找帮助来修复这个错误，因为我还不能得到输出显示。

Answer 1

使用encoding='latin-1

df = pd.read_csv('Meteo.csv', encoding='latin-1', parse_dates=[['DATE', 'TIME']])
print(df)
DATE_TIME TEMPERATURE DEW POINT HUMIDITY WIND WIND SPEED WIND GUST  PRESSURE PRECIPITATION CONDITION
0 2022-01-01 00:00:00       77 °F     72 °F     83 %  VAR      2 mph     0 mph  29.79 in        0.0 in      Fair
1 2022-01-01 01:00:00       75 °F     72 °F     89 %  VAR      1 mph     0 mph  29.79 in        0.0 in      Fair
2 2022-01-01 02:00:00       75 °F     72 °F     89 %    N      3 mph     0 mph  29.79 in        0.0 in      Fair
3 2022-01-01 03:00:00       75 °F     72 °F     89 %    N      3 mph     0 mph  29.76 in        0.0 in      Fair
4 2022-01-01 04:00:00       75 °F     72 °F     89 %  VAR      3 mph     0 mph  29.76 in        0.0 in      Fair