关于pandas

1.写文件

import pandas as pd
df = pd.DataFrame([[1,2],[3,4]])#创建对象

file_name = 'dsl.xlsx'
df = pd.read_excel(file_name) #读取文件

data = {'名字': ['张三','李四'],
        '分数': [100, 100]
       }
res= pandas.DataFrame(data)   #写入文件
res.to_excel('1.xlsx', sheet_name='Sheet1',index=False)# index = False表示不写入索引

2.读文件

import pandas as pd

df = pd.read_csv('./output.csv')
print(df)

3.分组统计

import pandas as pd
data = pd.read_excel('./data_min.xlsx')
grouped = data.groupby('Station_Id_C')
print(grouped )

4.筛选

import pandas as pd

df = pd.read_csv('./output.csv')
#筛选条件
filter_data= df[(df['LAT'] >= -90) & (df['LAT'] < 90) &
                        (df['LON'] >= -180) & (df['LON'] < 180)]
print(filter_data)