/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

19 votes283 views1 answer
Python string cut right
Python
36 votes255 views4 answers
Sort list of dictionaries python by value
Python
0 vote269 views1 answer
How to set propee timeline in python
Python
0 vote292 views1 answer
Python detect warning
Python
2 votes258 views1 answer
Flask if statement
Python
0 vote256 views1 answer
Pylatex tab
Python
1 vote271 views1 answer
Procfile for flask app
Python Flask
2 votes268 views1 answer
Python read text file look for string
Python
0 vote294 views1 answer
Python launch ipython from script
Python
-1 vote293 views1 answer
Print something after sec python
Python