我有一個文本文件,其中包含每 3 行重復(fù)一次的數(shù)據(jù)??梢哉f是hash,directory,sub directory。數(shù)據(jù)如下所示:a3s2d1f32a1sdf321asdfDir_321321Dir2_asdfs21a3s21d3f21as32d1fDir_65465Dir2_werqasd21231asdfa3s21dDir_76541Dir2_wbzxc....我創(chuàng)建了一個 python 腳本來獲取數(shù)據(jù),每 3 行創(chuàng)建一列:import pandas as pddf1 = pd.read_csv('RogTest/RogTest.txt', delimiter = "\t", header=None)df2 = df1[df1.index % 3 == 0]df2 = df2.reset_index(drop=True) df3 = df1[df1.index % 3 == 1]df3 = df3.reset_index(drop=True)df4 = df1[df1.index % 3 == 2]df4 = df4.reset_index(drop=True)df5 = pd.concat([df2, df3], axis=1)df6 = pd.concat([df5, df4], axis=1)#Rename columnsdf6.columns = ['Hash', 'Dir_1', 'Dir_2']#Write to csvdf6.to_csv('RogTest/RogTest.csv', index=False, header=True) 這工作正常,但我很好奇是否有更有效的方法來做到這一點,也就是更少的代碼?
Python 每三行到列使用 Pandas
寶慕林4294392
2021-08-17 16:58:09