dataframe数组做元素_pd.DataFrame的基本操作

1. 转置

.T方法

import pandas as pd
lst=[["转","置"],
     ["转","置"],
     ["转","置"]]
df=pd.DataFrame(lst,["行0","行1","行2"],["列0","列1"])
print(df)
print(df.T)

2. 查看DataFrame头部数据, 尾部数据

.head()方法, 查看Series头部(前几个)数据.

.tail()方法, 查看Series尾部(后几个)数据.

import pandas as pd
arr=np.arange(21).reshape(7,3)
df=pd.DataFrame(arr)
print(df) 
print(df.head(1)) # 查看第1个数据
print(df.tail()) # 默认查看5条

3. DataFrame数据索引 [超级重要]

3.0 查看索引

.columns方法, 查看列标签. .index方法, 查看行标签.

import numpy as np
import pandas as pd
lst=[[1,2,3],
     [4,5,6],
     [7,8,9]]
idx=["idx0","idx1","idx2"] 
clm=["clm0","clm1","clm2"] 
df=pd.DataFrame(lst,index=idx,columns=clm)
print(df) 
print(df.columns) # 查看列标签
print(df.index)   # 查看行标签

3.1 标签索引

按标签, 索引列, df[列标签]

import pandas as pd
lst=[[1,2,3],
     [4,5,6],
     [7,8,9]]
idx=["idx0","idx1","idx2"] 
clm=["clm0","clm1","clm2"] 
df=pd.DataFrame(lst,index=idx,columns=clm)
print(df)
print(df["clm0"]) # 索引"clm0"列,得到Series
print(df[["clm0"]]) # 索引"clm0"列,得到DataFrame
print(df[["clm0","clm2"]]) # 索引"clm0"和"clm2"列, 得到DataFrame

# 按属性,索引列
import pandas as pd
lst=[[1,2,3],
     [4,5,6],
     [7,8,9]] 
idx=["idx0","idx1","idx2"] 
clm=["clm0","clm1","clm2"] 
df=pd.DataFrame(lst,index=idx,columns=clm)
print(df.clm0)

按标签, 索引行, df.loc[行标签]

import pandas as pd
lst=[[1,2,3],
     [4,5,6],
     [7,8,9]]
idx=["idx0","idx1","idx2"] 
clm=["clm0","clm1","clm2"] 
df=pd.DataFrame(lst,index=idx,columns=clm)
print(df)
print(df.loc["idx0"]) # 索引"idx0"行,得到Series
print(df.loc[["idx0"]]) # 索引"idx0"行,得到DataFrame
print(df.loc[["idx0","idx2"]]) # 索引"idx0"和"idx2"行, 得到DataFrame