I have data in multiple csvs with a variable number and name of columns like this and I need help figuring out how to create a dataframe with the first two columns (Day and Name) fixed and the rest of them transposed with the names and values.
file_1 = 'Day','Account','a','b','c'
file_2 = 'Day','Account','e','b','g','h','i','j'
file_3 = 'Day','Account','a','b','c','xyz'
Final output would be like this with the name and value being the columns and values from each of those files.
'Day','Account','Name','Value'
