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

9 votes117 views4 answers
Pandas count number of rows with value
Python
6 votes173 views4 answers
Django change password command line
Python Django
1 vote111 views1 answer
Euclidean division in python
Python
10 votes111 views2 answers
English to japanese
Python
0 vote112 views2 answers
Generate random token or id in django
Python
0 vote116 views1 answer
"PyGTK" python setup.py egg_info Check the logs for full command output.
Python
0 vote130 views1 answer
Program to find the largest of three numbers in python
Python
3 votes141 views2 answers
Python button click code
Python
4 votes152 views2 answers
Django reset database
Python Django
75 votes112 views6 answers
How to reverse string in python
Python