How to convert CSV columns to text in Python?

Last Updated : 13 Jan, 2021

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

Attention geek! Strengthen your foundations with the Python Programming Foundation Course and learn the basics.

To begin with, your interview preparations Enhance your Data Structures concepts with the Python DS Course.

My Personal Notes

Related Articles

Python3

How to convert all csv column to text ?

Python3