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 votes187 views1 answer
Maping value to data in pandas dataframe
Python
1 vote189 views1 answer
How to print hello world 10 times in python
Python
31 votes266 views6 answers
Django admin create superuser
Python
0 vote273 views1 answer
Eval how
Python
1 vote190 views1 answer
Get local python api image url
Python
0 vote215 views1 answer
Como calcular el rango en python
Python
0 vote180 views1 answer
How to flatten the image dataset
Python
0 vote178 views1 answer
Global /tmp/pip-req-build-civioau0/opencv/modules/videoio/src/cap_v4l.cpp (587) autosetup_capture_mode_v4l2 VIDEOIO(V4L2:/dev/video0): device is busy
Python
7 votes170 views1 answer
Program python factorial
Python
0 vote177 views2 answers
Trace table python
Python