/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

2 votes145 views2 answers
Numpy remove object from array
Python
0 vote135 views1 answer
Add variable to print python
Python
0 vote140 views1 answer
Doublespace in python
Python
2 votes154 views2 answers
Save a Dictionary to File in Python Using the dump Function of the pickle Module
Python
8 votes136 views3 answers
Get_dummies
Python
0 vote141 views1 answer
Python pseudocode functions
Python
0 vote149 views2 answers
Auto py to exe download for windows
Python
6 votes139 views2 answers
Python selenium save cookies
Python
0 vote136 views1 answer
Python lxml get parent
Python
3 votes107 views1 answer
Modulenotfounderror: no module named 'png'
Python