pandas.DataFrame - get the UID of each row?

Question

After using yfinance.download(), I result in a pandas.DataFrame object, that, when printed, outputs to this:

Date                                                                                    
2018-01-02  18700.199219  18700.199219  18700.199219  18700.199219  18700.199219       0
2018-01-03  18953.099609  18953.099609  18953.099609  18953.099609  18953.099609       0
2018-01-04  18922.500000  18922.500000  18922.500000  18922.500000  18922.500000       0
2018-01-05  18849.800781  18849.800781  18849.800781  18849.800781  18849.800781       0
2018-01-08  18911.900391  18911.900391  18911.900391  18911.900391  18911.900391       0
...                  ...           ...           ...           ...           ...     ...
2022-03-04  23165.710938  23165.710938  23165.710938  23165.710938  23165.710938       0
2022-03-07  23148.070312  23148.070312  23148.070312  23148.070312  23148.070312       0
2022-03-08  23026.910156  23026.910156  23026.910156  23026.910156  23026.910156       0
2022-03-09  22659.669922  22659.669922  22659.669922  22659.669922  22659.669922       0
2022-03-10  22437.609375  22437.609375  22437.609375  22437.609375  22437.609375       0

[1061 rows x 6 columns]

I called it the UID since it is a unique identifier (I.e. special for each row) and it does not get classified as an column.

How do I access the data from the "Date" column?

Index(['Open', 'High', 'Low', 'Close', 'Adj Close', 'Volume'], dtype='object') — James Ashwood, Mar 13 '22 at 19:21
@JamesAshwood , ouput as given in the question is strnge. where are the column names? — hpchavaz, Mar 13 '22 at 20:02

Joost Döbken · Accepted Answer · 2022-03-28T07:03:41.570

0

How do I access the data from the "Date" column?

Reset the index first, and convert the index to a regular column:

df.reset_index()['Date']

OR, keep Date column as your index and simply get the index column:

df.index

edited Mar 28 '22 at 07:03

answered Mar 13 '22 at 19:27

Joost Döbken

3,450
2
35
79

2

`df.index` would also work – Paul H Mar 13 '22 at 19:39
@JamesAshwood take sometime to think about Paul H answer. Are you sure that having `Date` as the index does not make more sense? – hpchavaz Mar 13 '22 at 20:07
It does, @PaulH, how would that work. – James Ashwood Mar 27 '22 at 13:48

pandas.DataFrame - get the UID of each row?

1 Answers1