How do I add a list which has headers to a Dataframe, if I do it directly using pl.DataFrame(list), it creates the headers for me and keeps everything as a string. And also transposes the list, whereby the first element in my list becomes the first column in the df.
my list;
[[‘Earnings estimate’, ‘Current qtr. (Jun 2024)’, ‘Next qtr. (Sep 2024)’, ‘Current year (2024)’, ‘Next year (2025)’], [‘No. of analysts’, ’13’, ’11’, ’26’, ’26’], [‘Avg. Estimate’, ‘1.52’, ‘1.62’, ‘6.27’, ‘7.23’], [‘Low estimate’, ‘1.36’, ‘1.3’, ‘5.02’, ‘5.88’], [‘High estimate’, ‘1.61’, ‘1.74’, ‘6.66’, ‘8.56’], [‘Year ago EPS’, ‘1.76’, ‘1.36’, ‘5.74’, ‘6.27’]]
Desired output;