目录
1.将列表转换成列:Series方法
import pandas as pd
a = [1, 2, 3]
myvar = pd.Series(a)
print(myvar)
输出结果如下:
1)指定索引值
import pandas as pd
a = ["Google", "Runoob", "Wiki"]
myvar = pd.Series(a, index = ["x", "y", "z"])
print(myvar)
输出结果如下:
x Google
y Runoob
z Wiki
dtype: object
2)读取列的数据
import pandas as pd
a = [1, 2, 3]
myvar = pd.Series(a)
print(myvar[1])
输出结果如下:
2
2.Dataframe将数据转换为表格
(1)import pandas as pd
data = [['Google',10],['Runoob',12],['Wiki',13]]
df = pd.DataFrame(data,columns=['Site','Age']) #columns指定列名
print(df)
(2)import pandas as pd
data = {
"calories": [420, 380, 390],
"duration": [50, 40, 45]
}
# 数据载入到 DataFrame 对象
df = pd.DataFrame(data)
print(df)
# 返回第一行和第二行
print(df.loc[[0, 1]])
输出结果如下:
(1) Site Age
0 Google 10
1 Runoob 12
2 Wiki 13
(2) calories duration
0 420 50
1 380 40
2 390 45
calories duration
0 420 50
1 380 40