1.如果文件名带有中文,否则报错Initializing from file failed
import pandas as pd
f=open(r"G:\移动\3论文\交通安全\Traffic and Pedestrain Signals\Traffic_and_Pedestrian_Signals.csv")
res=pd.read_csv(f)
print(res.values)
2.输出文件的前后五行、长度、类型
print(res.head())
print(res.tail())
print(len(res))
print(res.dtypes)
3.对数据切片,输出LANDMARK列最后两行
import pandas as pd
f=open(r"G:\移动\3论文\交通安全\Traffic and Pedestrain Signals\Traffic_and_Pedestrian_Signals.csv")
res=pd.read_csv(f)
landmark=res[‘LANDMARK’]
print(landmark[-2:])
或者 print(res[‘LANDMARK’][-2:])
4.输出LANDMARK列
print(landmark)
print(type(landmark)
5.转至
print(res.T)
6.打印一列
print(res[‘SIGNAL_ID’])
7.打印signalid值为1005的所有数据
signalid=res[‘SIGNAL_ID’]
print(res.loc[signalid[1005]])
8输出一个矩阵的数据
print(res.iloc[1:3,2:4])
9输出制定一列
signalid=res[‘SIGNAL_ID’]
print(res.loc[signalid[100]])
10输出指定位置的数据
print(res.iloc[24,2])
11.倒数第二列数据乘以0.5
print(-0.5*res[res.columns[-2]])