Python Forum
Automatically plot each variable on the same graph for each "ID" - Printable Version

+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: Data Science (https://python-forum.io/forum-44.html)
+--- Thread: Automatically plot each variable on the same graph for each "ID" (/thread-17543.html)



Automatically plot each variable on the same graph for each "ID" - AdWill97 - Apr-15-2019

Hello, I am currently doing an Internship and have been tasked with writing a code that will automatically plot values in a dataframe based on their ID number. I cant add a picture but its like this:
Output:
Index-----------ID--------Timestamp---------Name----------Value 0-----------1553679924-----Date/Time--------T_Amb---------4.5 1-----------1553679924-------""--------------""-----------4.6 2---------------""-----------""--------------""-----------4.2 3---------------""-----------""----------- T_HTES---------340 4---------------""-----------""--------------""-----------341 etc. 1555--------1553683993-------""--------------""------------"" 1556--------1553683993-------""--------------""------------""
there are multiple variable under Name eg. T_Amb, T_HTES, Pel_KWKK, CHP_Switch etc. each ID number has every variable (a reading for each variable was taken every 15 minutes).
The aim is to plot each variable under "Name" on the same graph based on the ID number with "Value" on the y-axis and "Timestamp" on the x-axis.
I hope i have explained it well enough, thanks in advance for any help. Smile
I have looked at what this looks like when posted please imagine the dashes as just seperating the columns i dont know how else to show it lol - Fixed(Yoriz)