Issue
I wrote code to append info to csv file like the following:
import csv
import pandas as pd
import random
from datetime import date
file_name = r"test.csv"
lst = []
X = input("Your name ")
N = random.random()
D = D = date.today()
lst.append(N)
lst.append(X)
lst.append(D)
with open(file_name, 'a') as f:
writer = csv.writer(f)
writer.writerow(lst)
df = pd.read_csv('test.csv')
print(df)
It works fine but when i opened the csv file i found some empty rows like this:
how to avoid this problem?
Solution
You can better avoid doing manual csv writing when you can do it much easier using pandas.
import csv
import pandas as pd
import random
from datetime import date
file_name = "test.csv"
lst = [random.random(), date.today()]
pd.DataFrame(lst).to_csv(file_name)
df = pd.read_csv(file_name)
print(df)
Answered By - Michel Kok Answer Checked By - Willingham (PHPFixing Volunteer)
0 Comments:
Post a Comment
Note: Only a member of this blog may post a comment.