CODEWITHSUNDEEP
pythonpandasdataframe
TisButaScratch
TisButaScratch

Reputation: 173

DataFrame with one column 0 to 100

I need a DataFrame of one column ['Week'] that has all values from 0 to 100 inclusive.

I need it as a Dataframe so I can perform a pd.merge

So far I have tried creating an empty DataFrame, creating a series of 0-100 and then attempting to append this series to the DataFrame as a column.

alert_count_list = pd.DataFrame()
week_list= pd.Series(range(0,101))
alert_count_list['week'] = alert_count_list.append(week_list)

Upvotes: 0

Views: 3713

Answers (3)

Joe
Joe

Reputation: 889

You can try:

week_vals = []
for i in range(0, 101):
    week_vals.append(i)

df = pd.Dataframe(columns = ['week'])
df['week'] = week_vals

Upvotes: 0

Parthasarathy Subburaj
Parthasarathy Subburaj

Reputation: 4264

Try this:

df = pd.DataFrame(columns=["week"])
df.loc[:,"week"] = np.arange(101)

Upvotes: 1

amalik2205
amalik2205

Reputation: 4172

alert_count_list = pd.DataFrame(np.zeros(101), columns=['week'])

or 

alert_count_list = pd.DataFrame({'week':range(101)})

Upvotes: 1

Related Questions