Insert numpy column in pandas data frame

Question

I need a data frame, which contains just one column which is filled with ones. Here is my code so far.

label_values = np.empty(10)
    label_values.fill(1)
    label_df = pd.DataFrame()
    label_df.insert(column=0, value=label_values.transpose(), allow_duplicates=True)

I get the following error:

    label_df.insert(column=0, value=label_values.transpose(), allow_duplicates=True)
TypeError: insert() missing 1 required positional argument: 'loc'

As far as I see the problem is that the position (row) for the insert is missing. Do I really need to iterate over the array and insert each single value?

Thanks in advance!

ivallesp · Accepted Answer · 2019-08-15 12:04:36Z

1

Try this!

label_values = np.empty(10)
label_values.fill(1)
label_df = pd.DataFrame()
label_df[0] = label_values

answered Aug 15, 2019 at 12:04

ivallesp

2,2421 gold badge17 silver badges24 bronze badges

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

Comments

Arkadi · Accepted Answer · 2019-08-15 12:28:36Z

1

Slightly shorter than the current proposal

pd.DataFrame(np.ones(10))

Or

pd.DataFrame(10*[1])

answered Aug 15, 2019 at 12:28

Arkadi

1986 bronze badges

Collectives™ on Stack Overflow

Insert numpy column in pandas data frame

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related