from_Series_to_DataFrame
def get_wanne_DataFrame_header(logFile):
title=[]
df=pd.read_csv(logFile) #这里把所有列的数据的name全写进title
for f in pd:
title.append(f) #倘若只想获取几列数据在下面写个list将title的对应的name写进去然后return list跟df即可
return title,df
def get_wanne_DataFrame_from_logFile(wanne_title_list,df_from_read_csv):
#df[title[0]] is a Series #then pd.DataFrame turn it into a DataFrame
df=df_from_read_csv
wanne_data=pd.DataFrame(df[title[0]])
for i in range (1,len(title)):
second=pd.DataFrame(df[title[1]])
wanne_data=pd.merge(wanne_data,second,left_index=True,right_index=True)
return wanne_data
def store_DataFrame_into_cv(wanne_data,store_path,store_name):
os.chdir(store_path)
dataframe.to_csv(store_name+'.csv',index=False,header=True)