Open In App

How to convert CSV columns to text in Python?

Improve
Improve
Like Article
Like
Save
Share
Report

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:

Python3




# 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:

Python3




# 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


Last Updated : 13 Jan, 2021
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads