In this article, you’ll learn how to convert a text (.txt) file into a CSV (comma-separated values) file using Python Pandas.
Given below is the step-by-step guide to convert a text (.txt) file into a CSV file using Python Pandas.
Steps To Convert Text (.txt) File To CSV Using Python Pandas
Create The Original Text File With Rows And Columns
First, create the original text file with the proper rows and columns structure.
In this example, we’ll be using a text file containing the roll numbers, names, classes, and scores of a few students. The fields in the text file are separated by commas, which is the default delimiter. You can also use a different delimiter of your choice, as discussed later in this article.
The text file, that we’re gonna convert to a CSV file in this example, is shown below.
Note: The first column is used for indexing by default when a text file is read.
Convert The Text File Into A CSV File Using Python Panda’s Dataframe.to_csv() Method
The Python code snippet required to convert a text file to CSV is given below:
import pandas as pd textdatafile = pd.read_csv("path to the txt file") textdatafile.to_csv("new csv file name", index = None)
After running the above code snippet a new csv file will be created in the same directory with the name mentioned inside the to_csv() function.
Here’s how the outputted CSV file would look:
Changing The Delimiter
As mentioned earlier in this article, the read_csv() method, of the pandas library of Python, expects the fields in the text to be separated by commas (,) by default.
However, we can include the delimiter parameter in the read_csv() to set our own delimiter.
For example, in the text shown below, the fields are separated by the “~” character.
In this case, we need to specify the delimiter in the read_csv() function as shown in the Python3 code snippet given below.
import pandas as pd textdatafile = pd.read_csv("path to the txt file", delimiter = '~') textdatafile.to_csv("new csv file name", index = None)
The CSV output shown below.
Specifying Own Headers
The pandas library also allows us to specify our own headers for columns if they’re not already mentioned in the text file.
Let’s take the example shown below, where there are no headers present for the columns.
In this case, we can insert the column headings using python pandas, while converting the file from TXT to CSV.
The Python3 code snippet is given below.
import pandas as pd textdatafile = pd.read_csv("path to the txt file", header = None) #adding column headings textdatafile.columns = ['Roll No.', 'Name', 'Class', 'Score'] textdatafile.to_csv("new csv file name", index = None)
When the code is executed, we get a new CSV file with all the fields and the column headings mentioned in the code. The CSV output is given below.
I hope this article helped you learn how to convert a text file into a CSV file using the pandas library of Python.
If you have any doubts or queries, feel free to comment down below. I will try my best to help you out.
Have a great day ahead!