This tutorial will teach you how to convert a Text (.txt) file to CSV using the pandas library in Python. I’ll give you the complete source code of this application so you could easily test it out on your PC.
Let’s get started by installing the pandas library using the pip
command.
pip install pandas
Now create a new Python file for this project and name it as code.py
. After that, copy the below-given code-snippet and paste it in code.py
.
# importing pandas library import pandas as pd # reading given csv from .txt file # and creating dataframe dataframe = pd.read_csv("file.txt", delimiter = ',') # storing this dataframe in a csv file dataframe.to_csv('new_file.csv', index = None)
According to our code, we need to provide a file.txt
that contains our data. By default, commas will be used as delimiters, but you can easily change them to whatever character you like.
So, let’s create a file.txt
in the root folder of your project and add some comma-separated values. For example, have a look at this file.
ID, Name, Score 1, Furqan, 100 2, Ibrar, 95 3, Ammar, 87 4, Sheraz, 90 5, Babur, 65
python code.py
A file named new_file.csv
will be generated automatically in your project’s root folder.
Here’s a screenshot of that file:
MiniMax-M1 is a new open-weight large language model (456 B parameters, ~46 B active) built with hybrid…
Managing Git hooks manually can quickly become tedious and error-prone—especially in fast-moving JavaScript or Node.js…
Git hooks help teams enforce code quality by automating checks at key stages like commits…
Choosing the right Git hooks manager directly impacts code quality, developer experience, and CI/CD performance.…
We evaluated the performance of Llama 3.1 vs GPT-4 models on over 150 benchmark datasets…
The manufacturing industry is undergoing a significant transformation with the advent of Industrial IoT Solutions.…