/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

11 votes136 views2 answers
Adding to python path
Python
0 vote125 views1 answer
How to remove role discord bot python
Python
0 vote125 views1 answer
How to deploy to heroku djangorest framework app
Python
0 vote156 views1 answer
Customise the django rest api view
Python Django
0 vote129 views1 answer
Sum with conditional python
Python
0 vote243 views1 answer
Django.com
Python
15 votes119 views5 answers
Check empty dataframe
Python
2 votes133 views1 answer
What happen when we apply * before list in python
Python
0 vote152 views2 answers
Flask return html
Python
0 vote127 views1 answer
Ipaddress in python
Python