Split by columns in CSV conversion

Question

I need to do a CRUD for student registration, and then soon after, convert this data to a spreadsheet, and for now, the save part to. csv is like this:

alunos_json = json.dumps(alunos, indent=True)

with open('abc.csv', 'w+') as file:
    file.write(alunos_json)

The problem is: when I open the file with the data of the program, the registered students are below each other:

And I wanted it to be sort of organized that way:

How can I do that?

Answer 1

import pandas as pd

alunos_json = json.dumps(alunos, indent=True)
df = pd.DataFrame(alunos_json)
df.to_csv(r'alunos.csv')

Install the pandas or use the https://colab.research.google.com

You can start here https://colab.research.google.com/drive/10Lm7b1UKK5Jq5oQgLUNUDOLWGTwz8DKl?usp=sharing