DataFrame基本操作

导入基本模块

import pandas as pdfrom pandas import DataFramefrom pandas import Series  #平行对比 numpy 模块的 ndarry 

手动一个数据框

df = DataFrame({        'id': Series([1, 2, 3]),        'name': Series(['赵', '钱', '孙'])        });

修改索引

df.index = df['id'] 

利用索引遍历

for i in df.index:    #print(i);    print(df.loc[i])

位置查找(loc, at)

#名称索引df.loc[range(2),'id':'name']df.loc[1:2, 'name']df.loc[[1,3],:]#位置索引print(df.iloc[0:2, :])print(df.iloc[0:, 0:])print(df.iloc[[0,2], :])#混合索引df.at[1, 'name']df.iat[0, 1]

数据框基本信息查看

print(df['id'])print(df.dtypes)print(df.index)print(df.columns)print(df.values)print(len(df))i = 0while i < len(df):    print(df.iloc[i])    i += 1    import osos.getcwd()  #获取当前工作目录    d = pd.read_excel('D:\\Michael\\Auto.xlsx')d.head()df2 = pd.read_csv('C:\\Users\\zz\\Desktop\\AUTO2.csv', encoding = 'gbk')df2.head()df2.columnstotal_counts = df['name'].value_counts()a = ['Auto Loyalty', 'auto']d.loc[d['Branch'].isin(a), '是否参加'] = 1df4 = pd.read_excel('path',sheetname = '调研店列表')d.to_excel('path', sheet_name = 'Auto', index = False, startrow = 2, startcol = 5)