美文网首页
from_Series_to_DataFrame

from_Series_to_DataFrame

作者: _Him | 来源:发表于2018-08-29 11:18 被阅读0次

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)

相关文章

网友评论

      本文标题:from_Series_to_DataFrame

      本文链接:https://www.haomeiwen.com/subject/foyhwftx.html