How can I print out just the index of a pandas dataframe?

Question

I'm trying to make a table, and the way Pandas formats its indices is exactly what I'm looking for. That said, I don't want the actual data, and I can't figure out how to get Pandas to print out just the indices without the corresponding data.

Answer 1

You can access the index attribute of a df using .index:

In [277]:  df = pd.DataFrame({'a':np.arange(10), 'b':np.random.randn(10)}) df Out[277]:    a         b 0  0  0.293422 1  1 -1.631018 2  2  0.065344 3  3 -0.417926 4  4  1.925325 5  5  0.167545 6  6 -0.988941 7  7 -0.277446 8  8  1.426912 9  9 -0.114189 In [278]:  df.index Out[278]: Int64Index([0, 1, 2, 3, 4, 5, 6, 7, 8, 9], dtype='int64') 

Answer 2

.index.tolist() is another function which you can get the index as a list:

In [1391]: datasheet.head(20).index.tolist() Out[1391]: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19]