如何在文本文件中多次重复相同的数据

Question

我在文本文件中有一些数据，我想重复多次。例如1000条记录

CustomerID, FirstName,LastName,phone

1,Orlando,Gee,245-555-0173   
2,Keith,Harris ,170-555-0127  
3,Donna,Carreras ,279-555-0130   
4,Janet,Gates,710-555-0173   
5,Lucy,Harrington,828-555-0186   
6,Rosmarie,Carroll,244-555-0112

我想要像这样的输出

CustomerID, FirstName,LastName,phone

1,Orlando,Gee,245-555-0173   
2,Keith,Harris ,170-555-0127  
3,Donna,Carreras ,279-555-0130   
4,Janet,Gates,710-555-0173   
5,Lucy,Harrington,828-555-0186   
6,Rosmarie,Carroll,244-555-0112
7,Orlando,Gee,245-555-0173   
8,Keith,Harris ,170-555-0127  
9,Donna,Carreras ,279-555-0130   
10,Janet,Gates,710-555-0173   
11,Lucy,Harrington,828-555-0186   
12,Rosmarie,Carroll,244-555-0112
--------------------
----------------------
994,Orlando,Gee,245-555-0173   
995,Keith,Harris ,170-555-0127  
996,Donna,Carreras ,279-555-0130   
997,Janet,Gates,710-555-0173   
998,Lucy,Harrington,828-555-0186   
999,Rosmarie,Carroll,244-555-0112

我该怎么办

Answer 1

首先将文本文件读入数据框：

import pandas as pd
pd_df = pd.read_csv('untitled.txt')
pd_df 



CustomerID  FirstName   LastName    phone
1           Orlando     Gee         245-555-0173
2           Keith       Harris      170-555-0127
3           Donna       Carreras    279-555-0130
4           Janet       Gates       710-555-0173
5           Lucy        Harrington  828-555-0186
6           Rosmarie    Carroll     244-555-0112

然后操纵并将其写回文本：

pd_df = pd_df.append([pd_df]*int(1000/6),ignore_index=True)
pd_df.loc[:,'CustomerID'] = range(1, pd_df.shape[0]+1)
pd_df = pd_df[pd_df.CustomerID<1000]
pd_df.to_csv('output.txt', index=False)