/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 vote210 views1 answer
Limit characters in django template
Python Django
0 vote159 views1 answer
Percentage change between the current and the prior element.
Python
0 vote146 views1 answer
How to end an infinite loop in specific time python
Python
16 votes135 views2 answers
Python how to remove n from string
Python
10 votes148 views6 answers
How to merge two dictionaries with same keys in python
Python
0 vote146 views1 answer
Create a distance matrix from a coordinate matrix in python
Python
0 vote156 views1 answer
Pil saves blue images
Python
0 vote144 views1 answer
Extract label from tf data
Python
1 vote159 views1 answer
ValueError: There may be at most 1 Subject headers in a message
Python
1 vote140 views1 answer
Deleting an object in python
Python