Pandas入门(1):Series和Dataframe方法

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
经验分享 程序员 微信小程序 职场和发展