Python converted txt to dsv

Answer 1

In Python, you can convert a txt-file to a dsv-file in the following ways:

** 1. Basic reading and writing operations **
1. ** Read the txt-file by line and write it into the dsv file according to the rules (using commas as an example)**
- Assuming that each line of the txt-file is separated by a specific character (such as `@@@` in the example), first open the txt-file to be converted and the dsv-file to be written.(Open the dsv-file in the binary-writing mode of `wk`, which is applicable in Python 2. In Python 3, you can use the `w` mode and specify the code as `utf - 8`).
- For the dsv file to be written, use `dsv.writer` to create a write object, then read the contents of the txt file line by line, divide each line into a list according to the terminator, and then use the `writerow` method to write the list into the dsv file. The sample code is as follows:
```python
import csv
#Read the txt-file to be converted. Each line of the file is separated by the @@@ character.
with open('top20_new.txt', 'r', encoding='utf - 8') as filein:
with open('file.csv', 'w', newline='') as csvfile:
spamwriter = csv.writer(csvfile)
for line in filein:
line_list = line.strip('\n').split('@@@')
spamwriter.writerow(line_list)
```
2. ** Directly convert according to the reading and writing method of a text file (Assuming that the fields are separated by commas)**
- Take writing to a dsv file as an example. First, open a file according to the writing method of a text file. Write the header (if there is) and data. Each data field is separated by commas. After writing each line of data, add a line break `\n`.
- When reading, open the file according to the text file reading method, read each line, then use the `strip` method to remove the line break, and then use the `split` method to separate the contents of each line into a list of fields with commas. The sample code is as follows:
```python
#Write to dsv file
with open('demo.csv', 'w', encoding='utf8') as file:
file.write('Name, Age, Gender')
file.write('Zhang San, 25, male')
file.write('Li Si, 30, male')
file.write('Wang Wu, 28, Male')
#Read dsv file
with open('demo.csv', 'r', encoding='utf8') as file:
for line in file:
fields = line.strip('\n').split(',')
print(fields)
```

** Second, use a third-party library (such as pandas) for conversion (suitable for processing complex structured data)**
1. First, you need to install the pandas library (if not installed).
2. Then use the `read_dsv` and `to_dsv` methods in the `pandas` library to convert. For example, if the content of the txt-file is a simple table structure, the following code can be converted:
```python
import pandas as pd
#Read the txt-file. Here, assume that the file content is a simple table structure, and the terminator is a commas.
df = pd.read_csv('input.txt')
#Write the data to the dsv file
df.to_csv('output.csv', index = False)
```
Read more exciting novels for free