import attended student CSV file to dataframe using python.
زياد عقباوي
1
Reputation point
hello I'm using Microsoft teams to teach students, after class, I save CSV file from teams contains attended ppl, I wrote a script to import data from the CSV file but the problem is the CSV file is encoded by UTF-16 and it's hard to read it in a data frame, and fields are separated by spaces, not commas. is there any way to download the file from teams as CSV UTF-8? It works when saving the file as UTF-8 from excel (save as), but it's not the flexible way. please I need help.