/Python/Pandas shift columns down until value

Pandas shift columns down until value

#We create a shift down method so that we can have all the preious summed values in the bottom index and hence
#deleting them would be easy 
def shift_down(data):
    i=0
    while(i<len(data.columns)):
        while(pd.isnull(data.iloc[len(data.index)-1,i])==True):
            data.iloc[:,i] = data.iloc[:, i].shift(1)
        i+=1
    return data

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

Similar codes

0 vote240 views1 answer
Check this id exist in database django
Python
0 vote194 views1 answer
Kable column names
Python
0 vote253 views1 answer
Django 3.2 compatible to python 3.10?
Python Django
10 votes304 views2 answers
Save machine learning model python
Python
3 votes170 views2 answers
Extract pdf text with python
Python
1 vote211 views2 answers
Valid parentheses
Python
3 votes190 views1 answer
Pickle load pickle file
Python
1 vote192 views1 answer
How to openn file dialog in tkinter
Python
0 vote179 views1 answer
Voice translate python
Python
4 votes179 views4 answers
Python hex
Python