Home > other >  How to use pandas TXT file to read text, and respectively.
How to use pandas TXT file to read text, and respectively.

Time:09-22

This file respectively symbol is a space there is no other sign
File image is as follows:
I used the read_csv, but not completely respectively, know how to respectively?

CodePudding user response:

Send go up, data file when the code can't be a word a word input, the format is different also, arguably, direct reading, natural respectively

CodePudding user response:

Reader=pd. Read_csv (filename, encoding="utf_8_sig", sep=', ', the iterator=True, usecols=line)
https://www.cnblogs.com/shenxi-ricardo/p/12123845.html

All of these show that sep is a delimiter, sep="" give it a try

CodePudding user response:

 
10, 0 100 1 20 November
20 1 14 of 17 26 23 82 124 1-2.090 1.410 34.360 0.040
- 0.00-0.00-0.00-0.00 0.00 0.00 0.00 0.00 3.97 3.82 3.75 3.97
0.00 0.00 0.00 0.00 0.00
30000.0000000 30000.0000000 0.0-32768-32768
0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.19 3.39
100 cm BT 0.47 0.187 dB
0.19 3.41 164.60 0.9 0.2 1.5 91.3 92.7 83.9-3.3-102.1, 100, 2147483647
0.29 3.89 153.56 1.7 0.1 0.6 88.6 90.9 84.9-3.5-94.6, 100, 2147483647
0.39 4.21 142.36 2.6 3.3 0.0 1.4 90.0 91.9 84.0 89.6, 100, 2147483647
0.49 2.33 149.82 1.2 2.0 0.4 0.3 90.5 87.7 84.9 87.7, 100, 2147483647
0.59 3.26 166.87 0.7 3.2 0.7 1.1 90.1 86.8 84.0 87.3, 100, 2147483647
0.69 3.47 165.86 0.8 3.4 0.6 0.6 88.3 85.5 83.6 86.4, 100, 2147483647
0.79 3.34 175.43 0.3 3.3 0.6 0.4 86.9 86.0 85.5 88.3, 100, 2147483647
0.89 11.20 141.50 7.0 1.1 4.2 87.9 92.1 85.1-8.8-89.8, 100, 2147483647
0.99 3.54 169.36 0.7 3.5 0.3 0.0 87.5 85.6 82.8 87.0, 100, 2147483647
1.09 3.14 161.59 1.0 3.0 0.4 1.0 88.0 83.8 81.9 87.0, 100, 2147483647


CodePudding user response:

Data of the previous seven line is irregular

CodePudding user response:

No, is copied into a column, still have to send in the cloud, don't

CodePudding user response:

Text uploaded to
Baidu network backup link: https://pan.baidu.com/s/1Z2BeRrAAPBV5X5LA5iYA7w
The extracted code: extp

The effect of eventually want is

CodePudding user response:

Still in excel directly import, use the program guide is too messy,
Data - from the text
  • Related