"""
dataframe、series
s1 = pd.Series([1,'a',5,2.7])
print(s1)
print(s1.index)
print(s1.values)
s2 = pd.Series([1,'a',5.2,7],index=['d','b','a','c'])
print(s2)
print(s2.index)
print(s2.values)
sdata = {'Ohio':35000,'Texas':72000,'Oregon':16000,'Utah':5000}
s3 = pd.Series(sdata)
print(s3)
print(s3['Ohio'])
print(s3[['Ohio','Texas']])
print(s3[1:2])
data = {
'state':['Ohio','Ohio','Ohio','Ohio','Ohio'],
'year':[2000,2001,2002,2003,2004],
'pop':[1.5,1.7,3.6,2.4,2.9]
}
df = pd.DataFrame(data)
print(df)
print(df.dtypes)
print(df.columns)
print(df.index)
# 查询一列：
print(df['year'])
# 查询多列：
print(df[['year','pop']])
# 查询一行：
print('-----------------')
print(df.loc[1])
print('-----------------')
print(df.loc[1:3])
"""
Processed:
0.009, SQL:
8
