/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

1 vote290 views1 answer
Service
Python
0 vote299 views1 answer
Create a distance matrix from a coordinate matrix in python
Python
1 vote263 views1 answer
Python remove multiple characters from string
Python
0 vote265 views1 answer
How to kill somene
Python
0 vote300 views1 answer
WARNING: Ignoring invalid distribution c program files python39libsite-packages
Python
0 vote281 views1 answer
How to plot a linear equation in matplotlib
Python
1 vote302 views1 answer
Message tags in django
Python Django
0 vote228 views1 answer
Unsupported operand type(s) for / 'fraction' and 'fraction'
Python
3 votes302 views1 answer
How to find the multiples of a number in python
Python
0 vote269 views1 answer
How to insert item at specifc index python
Python