1.导入模块
>>> import pandas as pd
2.解决DataFrame中的行列显示不全问题
>>> pd.set_option('display.max_rows', 100,'display.max_columns', 1000,"display.max_colwidth",1000,'display.width',1000)
3.导入数据表格
>>> air_quality = pd.read_csv(r"C:\Users\Administrator\Desktop\air_quality_no2.csv", index_col=0, parse_dates=True)
>>> air_quality.head()
station_antwerp station_paris station_london
datetime
2019-05-07 02:00:00 NaN NaN 23.0
2019-05-07 03:00:00 50.5 25.0 19.0
2019-05-07 04:00:00 45.0 27.7 19.0
2019-05-07 05:00:00 NaN 50.4 16.0
2019-05-07 06:00:00 NaN 61.9 NaN
4.两列相除得到新列,添加列"ratio_paris_antwerp",
>>> air_quality["ratio_paris_antwerp"] = air_quality["station_paris"] / air_quality["station_antwerp