I have a multi indexed file with values such as these
How could I plot a dataframe that has separate lines for each symbol in the same graph?
3
-
There are all symbol unique?jezrael– jezrael2019-09-29 05:06:29 +00:00Commented Sep 29, 2019 at 5:06
-
No, it repeats MSFT, GOOG, AAPL, MSFT, GOOG, APPL, etcEvan Kim– Evan Kim2019-09-29 05:17:41 +00:00Commented Sep 29, 2019 at 5:17
-
OK, so use second solution.jezrael– jezrael2019-09-29 05:18:12 +00:00Commented Sep 29, 2019 at 5:18
Add a comment
|
1 Answer
I believe you need pivot for all unique symbol values :
df1 = df.pivot(index='4.timestamp', columns='1.symbol', values='2.price')
If possible duplicated is becessary aggregate by DataFrame.pivot_table:
df1 = df.pivot_table(index='4.timestamp', columns='1.symbol', values='2.price', aggfunc='mean')
and then plot by DataFrame.plot:
df1.plot()
