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
