python合并报表_Python之pandas表格合并

1.导入模块

>>> import pandas as pd

>>> pd.set_option('display.max_rows', 100,'display.max_columns', 1000,"display.max_colwidth",1000,'display.width',1000) #设置显示

2.导入数据

>>> air_quality_no2 = pd.read_csv(r"C:\Users\Administrator\Desktop\air_quality_no2_long.csv", parse_dates=True)

>>> air_quality_no2 = air_quality_no2[["date.utc", "location", "parameter", "value"]]

>>> air_quality_no2

date.utc location parameter value

0 2019-06-21 00:00:00+00:00 FR04014 no2 20.0

1 2019-06-20 23:00:00+00:00 FR04014 no2 21.8

2 2019-06-20 22:00:00+00:00 FR04014 no2 26.5

3 2019-06-20 21:00:00+00:00 FR04014 no2 24.9

4 2019-06-20 20:00:00+00:00 FR04014 no2 21.4

... ... ... ... ...

2063 2019-05-07 06:00:00+