Python Forum
How to covert raw data into panel data - Printable Version

+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: Homework (https://python-forum.io/forum-9.html)
+--- Thread: How to covert raw data into panel data (/thread-10589.html)



How to covert raw data into panel data - jason413 - May-26-2018

How do I convert datastream time-series raw data with two variables (stock price & market cap) into panel data? In particular, How do I reshape it to the format with the column labels of panel data ['Date', 'Name', 'Stock Price', 'market Cap'] in python? [Image: search?tbm=isch&source=hp&biw=1920&bih=9...arFJ0GTtM:]

Thanks for your help.


RE: How to covert raw data into panel data - gruntfutuk - May-26-2018

Have you looked at the pandas library?

There is specific support for panels, although this has been deprecated in favour of richer dataframe options that should meet your needs.