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