I am a beginner in python. I need help with the following
I have a comma separated csv file, eg
a,b,c
d,e,f
g,h,i
I need to convert to a string variable eg s='a,b,c\n,d,e,f\n,g,h,i\n'
I tried something, but i am going wrong somewhere.
import os
import csv
Filename=r"c:\Users\das\Desktop\a.csv"
z=open(Filename, 'r')
reader=csv.reader(Filename.split('\n'),delimiter=',')
def csv2str():
for row in reader:
v=','.join(row)
a=csv2str()
You don't need the csv module to do that. Just call the read method of the file object to read in all the lines as one string:
with open(filename) as f:
s = f.read() + '\n' # add trailing new line character
print(repr(s))
# 'a,b,c\nd,e,f\ng,h,i\n'
I'm printing the repr of the string because a print of the string itself i.e. print(a) will not show the newline character as \n, but will show the string in its different lines.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With