Home > other >  Pandas data processing, turn XLSX TXT to extract the corresponding data
Pandas data processing, turn XLSX TXT to extract the corresponding data

Time:04-23

Novice to learn for several days, but suddenly have to deal with these data, feeling and technology is not high, straight-tempered to CSDN help bosses
Data processing:
Raw data: TXT, a total of five columns, the first column is the id (range: 28000-28500), the second column is (date) (month) (year) (year), the third column is the corresponding time (update time, 10 minutes a day. There are 144 data), the fourth column was useless, the fifth column is id corresponding data,
Data processing is completed: XLSX file, TXT the third column corresponding to the transverse XLSX from 1 to 144, the vertical column is 20 id (ordered by the first day of each month), just 20 id of the first month of random data

Data processing is completed as follows (sample) :


  • Related