csv数据的读取
import pandas as pd
dat=pd.read_csv('D:/data/data/sta.csv',parse_dates=['time'])
print(dat.dtypes)
print('-------')
print(dat)
time datetime64[ns]
station int64
t float64
tmax float64
tmin float64
dtype: object
-------
time station t tmax tmin
0 2020-03-01 58238 8.7 12.5 1.3
1 2020-03-01 58235 7.5 11.3 0.8
2 2020-03-01 58237 8.5 11.8 1.2
3 2020-03-02 58238 9.5 13.3 4.4
4 2020-03-02 58235 8.3 12.8 4.0
5 2020-03-02 58237 8.8 12.9 4.2
6 2020-03-03 58238 13.1 14.5 10.1
7 2020-03-03 58235 12.4 13.7 9.6
8 2020-03-03 58237 13.0 14.1 10.0
9 2020-03-04 58238 10.3 13.8 5.2
10 2020-03-04 58235 9.8 12.9 4.5
11 2020-03-04 58237 10.1 13.1 4.8
import numpy as np
import pandas as pd
dat=pd.read_csv('D:/data/data/sta.csv',parse_dates=['time'],dtype={'station':np.unicode_})
print(dat.dtypes)
print('-------')
print(dat)
time datetime64[ns]
station object
t float64
tmax float64
tmin float64
dtype: object
-------
time station t tmax tmin
0 2020-03-01 58238 8.7 12.5 1.3
1 2020-03-01 58235 7.5 11.3 0.8
2 2020-03-01 58237 8.5 11.8 1.2
3 2020-03-02 58238 9.5 13.3 4.4
4 2020-