Why can't I define column names when I create the dataframe with pandas?

Question

import pandas as pd

DF = pd.DataFrame(DICTIONARY, 
                  index = [r"$\lambda$="+str(i) for i in range(3)],
                  columns = [r"$\xi$="+str(j) for j in range(3)])

There are a few times when I have a dictionary (not very large) and try to convert it into a dataframe, the code above would yield one with each cell being NaN. Yet the code below works fine. I wonder what could be the difference?

DF = pd.DataFrame(DICTIONARY, index = [r"$\lambda$="+str(i) for i in range(3)])
DF.columns = [r"$\xi$="+str(j) for j in range(3)]

Maximus · Accepted Answer · 2020-10-05 08:08:59Z

1

What are your dictionary keys? I am guessing the keys don't align to your columns.

In the second option you are letting pandas assign default column names and then overwriting them.

Something like the below code works when the column names align - but explicitly defining the columns parameter, in this case, adds no value because the dict key already provides the names.

DF = pd.DataFrame({1:1,2:2,3:3},
    index = [r"$\lambda$="+str(i) for i in range(3)],
    columns = [j+1 for j in range(3)])

answered Oct 5, 2020 at 8:08

Maximus

1,32010 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Paw in Data Over a year ago

Aren't you a genius...^_^ You're right about the dictionary keys! Thank you!

Collectives™ on Stack Overflow

Why can't I define column names when I create the dataframe with pandas?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related