/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 vote208 views1 answer
Dictionary Get All Keys
Python
2 votes178 views1 answer
Python get all methods of object
Python
0 vote190 views1 answer
Python show charracter code
Python
9 votes189 views1 answer
Json formatter terminal
Python
0 vote227 views1 answer
?: (corsheaders.E013) Origin '.' in CORS_ORIGIN_WHITELIST is missing scheme or netloc HINT: Add a scheme (e.g. https://) or netloc (e.g. example.com).
Python
0 vote188 views1 answer
Rebuild database from zero django postgres
Python
0 vote188 views1 answer
How to write a dataframe to s3 object in python
Python
2 votes223 views1 answer
Set http response content type django
Python Django
2 votes186 views1 answer
Get guild from a channel discord py
Python
0 vote224 views1 answer
Python list clear vs del
Python