How to convert CSV columns to text in Python?
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
import pandas as pd
df = pd.read_csv( 'datasets/Fruit.csv' )
a = list (df[ 'FRUIT_NAME' ])
b = ' ' .join( str (e) for e in a)
print (b)
d = list (df[ 'PRICE' ])
e = '\n' .join( map ( str , d))
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
text = open ( "datasets/Fruit.csv" , "r" )
text = ' ' .join([i for i in text])
text = text.replace( "," , " " )
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
Share your thoughts in the comments
Please Login to comment...