creating dataframe with a given number of rows and a repeated value

Question

I need to create a dataframe with a given number of rows, say for instance it is n and with a unique value stored in a variable, for instance, unique_value.

Given n = 6 and unique_value = 25, the expected output would be a dataframe with a single column, 6 rows and in all of them, a 25:

drec4s · Accepted Answer · 2019-05-04 15:23:03Z

5

Like this?

import pandas as pd

n = 6
unique_value = 25
df = pd.DataFrame([unique_value] * n)

#print(df)
#    0
#0  25
#1  25
#2  25
#3  25
#4  25
#5  25

edited May 4, 2019 at 15:23

answered May 4, 2019 at 12:46

drec4s

8,1178 gold badges35 silver badges56 bronze badges

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

Comments

anky · Accepted Answer · 2019-05-04 13:06:37Z

2

Another way is using : np.ones() which:

Returns a new array of given shape and type, filled with ones.

df=pd.DataFrame(np.ones(n)*unique_value)
print(df)

answered May 4, 2019 at 13:06

anky

75.3k11 gold badges46 silver badges76 bronze badges

Collectives™ on Stack Overflow

creating dataframe with a given number of rows and a repeated value

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