CODEWITHSUNDEEP
pythonpandas
blknt3191
blknt3191

Reputation: 3

adding rows based on missing data

I have a currency data based on minutes like below. What I want to do is if one minute is missing for example if it jumps to 00:05:00 from 00:02:00 I want to create a new row with same 'Date' and 'AUDJPY' value. I want below dataframe to be: I have no idea what to do, I could not even understand how to add rows based on conditionality.

AUDJPY       Date      Time
    0  76.150 2020-01-02  00:00:00
    1  76.151 2020-01-02  00:01:00
    2  76.152 2020-01-02  00:02:00
    3  76.162 2020-01-02  00:05:00
    4  76.164 2020-01-02  00:06:00
    5  76.175 2020-01-02  00:07:00
    6  76.162 2020-01-02  00:08:00
    7  76.153 2020-01-02  00:09:00

 

      AUDJPY       Date      Time
    0  76.150 2020-01-02  00:00:00
    1  76.151 2020-01-02  00:01:00
    2  76.152 2020-01-02  00:02:00
    3  76.152 2020-01-02  00:03:00
    4  76.152 2020-01-02  00:04:00
    5  76.162 2020-01-02  00:05:00
    6  76.164 2020-01-02  00:06:00
    7  76.175 2020-01-02  00:07:00
    8  76.162 2020-01-02  00:08:00
    9  76.153 2020-01-02  00:09:00

Upvotes: 0

Views: 43

Answers (1)

Nk03
Nk03

Reputation: 14949

You can try:

df['Date-Time'] = pd.to_datetime(df['Date'] + ' ' + df['Time'])
k = df.set_index('Date-Time').asfreq('T').fillna(method = 'ffill').drop(['Date', 'Time'], 1).reset_index()

If you want to separate date/time from Date-time:

k[['Date', 'Time']] = k['Date-Time'].astype(str).str.split(' ', expand = True)

Upvotes: 1

Related Questions