/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 vote300 views1 answer
Sns how to change color if negative or positive
Python
0 vote280 views1 answer
Summarizing Data and description data in pandas
Python
0 vote308 views1 answer
Flask Upload file to local s3
Python Flask
-1 vote315 views1 answer
How to make label background transparent in tkinter
Python
7 votes314 views1 answer
Change value in pandas dataframe cell
Python
34 votes280 views4 answers
Reindex pandas dataframe from 0
Python
0 vote276 views1 answer
Customise django admin edit model button in field
Python
0 vote262 views1 answer
Django not migrating
Python
4 votes320 views2 answers
Convert array to dataframe python
Python
3 votes265 views1 answer
Get common elements from two lists
Python