How do I convert text file to CSV file with only plain python Meaning no panda or any other special module

Question

I'm trying to implement slice string into a text to csv converter and my document has rows and columns. I'm very new to coding and even newer to python so im unsure ow to go about this. Although i'm trying to use plain python and not use any odules or library functions like pandas and etc. I'd really appreciate some help! Please and Thank you!

Answer 1

Hi, @There,

Regarding your query, I would suggest you go through this https://www.edureka.co/community/53835/python-convert-txt-file-to-csv-format-with-rows-and-columns   It has multiple solutions given that you will need to solve your Query. 

I hope it helps!!!

Comments

Hi there! The answers only included using special modules (ie panda) I appreciate the help tho!

Answer 2

Steps to Convert Text File to CSV using Python

Step 1: Install the panda's package

If you haven’t already done so, install the panda's package. You may use the following command to install the panda's package under Windows:

pip install pandas

Step 2: Capture the path where your text file is stored:

Next, capture the path where the text file is stored on your computer.

For example, I stored a text file (called Product_List) under the following path: C:\Users\Ron\Desktop\Test

Step 3:

Finally, you may use the template below in order to facilitate the conversion of your text file to CSV:

import pandas as pd

read_file = pd.read_csv (r'Path where the Text file is stored\File name.txt')
read_file.to_csv (r'Path where the CSV will be saved\File name.csv', index=None)

For our example:

• The path where the Text file is stored is: C:\Users\Ron\Desktop\Test\Product_List.txt
  • Where the file name is Product_List and the file extension is txt
• The path where the CSV will be saved is C:\Users\Ron\Desktop\Test\New_Products.csv
  • Where the new file name to be created is New_Products and the file extension is CSV

So this is the complete code to convert the Text file to CSV for our example:

import pandas as pd

read_file = pd.read_csv (r'C:\Users\Ron\Desktop\Test\Product_List.txt')
read_file.to_csv (r'C:\Users\Ron\Desktop\Test\New_Products.csv', index=None)

Once you run the code (adjusted to your paths), you’ll get the CSV file at your specified location:

Comments

Hi there im sorry i can't use pandas

---

Hey,

If you are  trying to convert that text into a .csv (table) using a python script, then you can follow  this:

You need to split the line first.

import csv

with open('log.txt', 'r') as in_file:
    stripped = (line.strip() for line in in_file)
    lines = (line.split(",") for line in stripped if line)
    with open('log.csv', 'w') as out_file:
        writer = csv.writer(out_file)
        writer.writerow(('title', 'intro'))
        writer.writerows(lines)