1 pandas.Series
1.pd.Series(相当于一维数组)
#pd.Series(data,index,dtype,name,copy)
#data:数据,index:索引,name:可修改该Serise名字,copy:拷贝数据,默认是false
import pandas as pd
import torch
a=[10,20,30,40,50]
A=pd.Series(data=a,index=[1,2,3,4,5],dtype=float,name='Money')
#如果没有指定index,默认是[0,1,2,3,4]
print(A)
index=[‘one’,‘two’,‘three’,‘four’,‘five’]
print(A[‘two’])
20.0
2.用键值对(字典)构造pd
a={'one':10,'two':20,'three':30,'four':40,'five':50}
A=pd.Series(data=a,dtype=float,name='Money')
print(A)
2 pandas.DataFrame
1.pandas.DataFrame二维数组
pandas.DataFrame( data, index, columns, dtype, copy)
index:行(默认从0开始),conlumns:列(默认从0开始)
2.列表法创建
import pandas as pd
a=[['one',10],['two',20],['three',30],['four',40],['five',50]]
A=pd.DataFrame(data=a,index=[1,2,3,4,5],columns=['level','money'])
print(A)
3.nadarrays 创建
import pandas as pd
a={'level':[1,2,3,4,5],'money':[10,20,30,40,50]}
A=pd.DataFrame(data=a,index=[1,2,3,4,5])
print(A)
4 字典法创建
** 每组字典是一行**
import pandas as pd
a=[{'level':1,'money':10},{'level':2,'money':20},{'level':3}]
A=pd.DataFrame(data=a)
print(A)
5 用 .loc[index]返回指定行
print(A.loc[2])
print(A.loc[[1,2]]), 返回多行[1-2]
3.pandas.csv(操作表格文件)
打开一个csv : pd.read_csv
import pandas as pd
data=pd.read_csv("F:\Datasets\data\\nyu2_test.csv")
print(data)
默认输出前五行和后五行,中间省略
print(data.to_string())将全部数据输出
也可以用data.to_csv将二维数组转化为表格
data.head(10) 读前十行数据
data.tail(10) 读后十行数据
data.info() 返回表格的基本信息