Pandas shift column up

Pandas shift columns up until value

#We create a function to shift up the data of each column up until the first actual number
def shift_up(data):
    i=0
    while(i<len(data.columns)):
        while(pd.isnull(data.iloc[0,i])==True):
            data.iloc[:,i]=data.iloc[:,i].shift(-1)
        i+=1
    return data

Source: grepper.com

Pandas shift column down

>>> df.shift(periods=3)
#Shifted down by 3 periods
#If you want to shift up insert the number of periods as a negative number
            Col1  Col2  Col3
2020-01-01   NaN   NaN   NaN
2020-01-02   NaN   NaN   NaN
2020-01-03   NaN   NaN   NaN
2020-01-04  10.0  13.0  17.0
2020-01-05  20.0  23.0  27.0

Source: pandas.pydata.org

Similar codes

3 votes245 views1 answer
Find duplicated rows with respect to multiple columns pandas
Python
0 vote290 views1 answer
Django allauth Reverse for 'password_reset_confirm' not found. 'password_reset_confirm' is not a valid view function or pattern name.
Python Django
1 vote269 views1 answer
Calculate pointbiseral correlation
Python
0 vote278 views1 answer
Opencv houghlines only horizontal
Python
0 vote243 views1 answer
How to make python script run forever
Python
1 vote298 views2 answers
Increase instagram followers using python
Python
0 vote254 views1 answer
Convert files from jpg to png and save in a new directory python
Python
0 vote271 views1 answer
Formate a phonenumber in phonenumber package with PhoneNumberFormat
Python
0 vote269 views1 answer
Python hide print output
Python
0 vote264 views1 answer
Setup python in windows tikinter
Python