How to convert CSV columns to text in Python?
Last Updated :
13 Jan, 2021
Improve
In this article, we are going to see how to convert CSV columns to text in Python, and we will also see how to convert all CSV column to text.
Approach:
- Read .CSV file using pandas dataframe.
- Convert particular column to list using list() constructor
- Then sequentially convert each element of the list to a string and join them using a specific character or space.
For our program we are going to use the following CSV file:
Code:
# importing library
import pandas as pd
# Then loading csv file
df = pd.read_csv('datasets/Fruit.csv')
# converting ;FRUIT_NAME' column into list
a = list(df['FRUIT_NAME'])
# converting list into string and then joining it with space
b = ' '.join(str(e) for e in a)
# printing result
print(b)
# converting 'PRICE' column into list
d = list(df['PRICE'])
# another way for joining used
e = '\n'.join(map(str, d))
# printing result
print(e)
Output:
Apple Banana JackFruit Orange Pineapple Guava Grapes Mango 100 70 30 120 90 50 80 200
How to convert all csv column to text ?
For this, we don't need to import any library.
Code:
# reading csv file
text = open("datasets/Fruit.csv", "r")
# joining with space content of text
text = ' '.join([i for i in text])
# replacing ',' by space
text = text.replace(",", " ")
#displaying result
print(text)
Output:
FRUIT_NAME PRICE Apple 100 Banana 70 JackFruit 30 Orange 120 Pineapple 90 Guava 50 Grapes 80 Mango 200
