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

0 vote250 views1 answer
Python list clear vs del
Python
0 vote274 views1 answer
Successful=true for number in range (3) print ("Attempt") if successful: print ("Successful") breal
Python
0 vote304 views1 answer
Python unique values from pandas.series of sets
Python
0 vote275 views1 answer
Import stock data from yahoo finance
Python
0 vote283 views1 answer
Numpy rolling 2d
Python
2 votes294 views1 answer
Pathlib path get directory of current file
Python
1 vote285 views1 answer
Django admin action
Python
-1 vote303 views1 answer
Python find if part of list is in list
Python
0 vote282 views1 answer
Image capture from camera python
Python
7 votes328 views3 answers
List of list to numpy array
Python