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:
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. And to begin with your Machine Learning Journey, join the Machine Learning - Basic Level Course
- 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 libraryimport pandas as pd # Then loading csv filedf = pd.read_csv('datasets/Fruit.csv') # converting ;FRUIT_NAME' column into lista = list(df['FRUIT_NAME']) # converting list into string and then joining it with spaceb = ' '.join(str(e) for e in a) # printing resultprint(b) # converting 'PRICE' column into listd = list(df['PRICE']) # another way for joining usede = '\n'.join(map(str, d)) # printing resultprint(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 filetext = open("datasets/Fruit.csv", "r") # joining with space content of texttext = ' '.join([i for i in text]) # replacing ',' by spacetext = text.replace(",", " ") #displaying resultprint(text) |
Output:
FRUIT_NAME PRICE Apple 100 Banana 70 JackFruit 30 Orange 120 Pineapple 90 Guava 50 Grapes 80 Mango 200
