ExportCSV.py

import pandas as pd
from pathlib import Path

class ExportCSV:

    def __init__(self, user):

        mypath = Path().absolute()
        df = pd.DataFrame(user, columns= ['User', 'E-mail'])

        df.to_csv (str(mypath) + r'\export_dataframe.csv', index = False, header=True, sep=';')
        print(df)

if __name__ == "__main__":

    user = {'User': ['User_01','User_02','User_03','User_04','User_05'],
            'E-mail': ['user@gmail.com','user@gmail.com','user@gmail.com','user@gmail.com','user@gmail.com']
        }

    ExportCSV(user)