import attended student CSV file to dataframe using python.

زياد عقباوي 1 Reputation point
2021-01-27T09:03:34.19+00:00

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.

Microsoft Teams Development
Microsoft Teams Development
Microsoft Teams: A Microsoft customizable chat-based workspace.Development: The process of researching, productizing, and refining new or existing technologies.
2,920 questions
{count} votes