/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

4 votes225 views2 answers
How to make django model field case insensitive
Python
0 vote222 views1 answer
Python multithreading tutorials
Python
0 vote227 views2 answers
Binary Search tree implementation in python
Python
1 vote209 views2 answers
How to append a tuple to a list
Python
0 vote217 views1 answer
Apply dictionary to df clumn
Python
1 vote231 views2 answers
Django drop database postgres
Python
21 votes262 views4 answers
Flask quickstart
Python Flask
1 vote506 views1 answer
How to check which submit button is clicked in flask wtf
Python
0 vote272 views1 answer
Del no of elements in lis
Python
2 votes217 views2 answers
Search in django
Python