Create a Form loaded with data from excel file

Question

I would like to build a form with predefined data from an excel file that is loaded into the form as well as having some additional columns within the form that can be editable?

Please can someone advise me how I could do this on Python?

Answer 1

try

import pandas as pd
df = pd.read_csv('your-excel.csv')
df = pd.DataFrame(df)
df

If you want to add columns:

Test = ['Test1', 'Test2', 'Test3', 'Test4']
df['Test'] = Test
df