import pandas as pd
import numpy as np
df=pd.read_csv('C:/Users/15451/data/1.csv')
df

df.info()

df[df.价格<1000]

df[(df.价格<1200)&(df.出发地=='成都')]

df[df.价格.between(1000,2000)].sort_values(by='价格')

df.groupby('出发地')['路线名'].size()

df.groupby('出发地')['价格'].agg([np.size,np.mean])

df.groupby(by=['出发地','目的地'])['价格'].agg([np.size,np.mean])

df.pivot_table(values=['价格'],index=['出发地'],columns=['目的地'],aggfunc=[np.size,np.mean])

df.head(2)

df['价格'].corr(df['星级'])