get symbol from a pandas dataframe

Question

I can print my data frame and see label TSLA but I don't know how to get that string from my variable...

>>> t.axes
[MultiIndex(levels=[['TSLA'], [2018-07-02 00:00:00, 2018-07-03 00:00:00, 2018-07
-04 00:00:00, 2018-07-05 00:00:00, 2018-07-06 00:00:00, 2018-07-09 00:00:00, 201
8-07-10 00:00:00, 2018-07-11 00:00:00, 2018-07-12 00:00:00, 2018-07-13 00:00:00,
 2018-07-16 00:00:00, 2018-07-17 00:00:00, 2018-07-18 00:00:00, 2018-07-19 00:00
:00, 2018-07-20 00:00:00]],
           labels=[[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], [0, 1, 2, 3, 4
, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14]],
           names=['Symbol', 'Date']), Index(['Close', 'High', 'Low', 'Open', 'Vo
lume'], dtype='object')]
>>>

`t.get_level_values(0)` or `t.get_level_values(1)` – YOLO Jul 21 '18 at 09:35 — YOLO, Jul 21 '18 at 09:35

score 2 · Accepted Answer · edited Jul 21 '18 at 09:40

2

Use pandas.index.get_level_values

In your case, probably

t.index.get_level_values(0).unique()[0]

edited Jul 21 '18 at 09:40

taras

6,566
10
39
50

answered Jul 21 '18 at 09:36

najeem

1,841
13
29

get symbol from a pandas dataframe

1 Answers1