Creating pandas dataframe with datetime index and random values in column

Question

How do I create a pandas dataframe with datetime as index, and random values for a column. Currently, I have this:

from datetime import datetime, timedelta

date_today = datetime.now()
date_end = date_today + timedelta(7)

df = pd.DataFrame(columns=['test'])

How do I proceed from here?

score 36 · Accepted Answer · edited Sep 13 '17 at 11:00

You can try this:

import pandas as pd
import numpy as np
from datetime import datetime, timedelta

date_today = datetime.now()
days = pd.date_range(date_today, date_today + timedelta(7), freq='D')

np.random.seed(seed=1111)
data = np.random.randint(1, high=100, size=len(days))
df = pd.DataFrame({'test': days, 'col2': data})
df = df.set_index('test')
print(df)


test                            
2017-03-22 10:07:41.914019    29
2017-03-23 10:07:41.914019    56
2017-03-24 10:07:41.914019    82
2017-03-25 10:07:41.914019    13
2017-03-26 10:07:41.914019    35
2017-03-27 10:07:41.914019    53
2017-03-28 10:07:41.914019    25
2017-03-29 10:07:41.914019    23

Abshakiba · Answer 2 · 2018-03-25T22:16:57.257

7

import pandas as pd
import numpy as np

df = pd.DataFrame(np.random.randint(0,30,size=10),
                  columns=["Random"],
                  index=pd.date_range("20180101", periods=10))

edited Mar 25 '18 at 22:16

answered Mar 25 '18 at 21:54

Abshakiba

333
3
6

how do i also add a index name to the data frame while creating it. something like ` pd.Dataframe( index={'date': pd.date_range(x,y) ) ` – bhavin Sep 25 '19 at 14:49

score 5 · Answer 3 · answered Mar 22 '17 at 02:13

My code for your reference

from datetime import datetime, timedelta
import pandas as pd
import numpy as np

date_today = datetime.now()
ndays = 7
df = pd.DataFrame({'date': [date_today + timedelta(days=x) for x in range(ndays)], 
                   'test': pd.Series(np.random.randn(ndays))})
df = df.set_index('date')

Creating pandas dataframe with datetime index and random values in column

3 Answers3

Linked