直接上码,简单易懂
execl如下:
import numpy as np
import pandas as pd
#生成execl
def create_execl():
#二维数据
data = [["直男", 23, 145],["猛男", 25, 159],["弱男", 34, 177]]
#数据填充
df = pd.DataFrame(data= data, columns=['类型', '现金', '胆固醇'])
#每列类型设置
df['胆固醇'] = df['胆固醇'].astype('uint32')
df['现金'] = df['现金'].astype('uint32')
df['类型'] = df['类型'].astype('str')
#设置index(索引行)
df.set_index(['类型'], inplace=True)
#生成execl
df.to_excel("xxxxxxxxx\\a.xlsx")
if __name__ == '__main__':
create_execl()
pass
结果:
h5文件如下:
dataframe格式数据生成的h5文件
import numpy as np
import pandas as pd
import h5py as h5
#生成execl
def create_h5():
#二维数据
data = [["路飞", 23, 145],["山治", 25, 159],["索隆", 34, 177]]
#数据填充
df = pd.DataFrame(data= data, columns=['武器', '视力', '发量'])
#每列类型设置
df['发量'] = df['发量'].astype('uint32')
df['视力'] = df['视力'].astype('uint32')
df['武器'] = df['武器'].astype('str')
#设置index(索引行)
df.set_index(['武器'], inplace=True)
##生成h5文件,以‘/’自动识别分层group
df.to_hdf("E:\\workspace\\01_Learning&output\\04_python\\01_pandas_test\\a.h5", key="men" + '/style_' + "sb")
if __name__ == '__main__':
create_h5()
pass