/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 vote193 views1 answer
Pandas drop column by index range
Python
0 vote199 views2 answers
Logout url
Python
0 vote201 views1 answer
To install a specific version, type the package name followed by the required version:
Python
2 votes205 views1 answer
How to check if a message includes a word discord.py
Python
0 vote236 views1 answer
Python nasa api
Python
2 votes196 views1 answer
Python system of nonlinear equations
Python
0 vote205 views1 answer
Convert pb to tb with python
Python
0 vote239 views1 answer
Df.fillna("tagline",inplace=True) in jupyter notebook
Python
12 votes286 views5 answers
Python get the intersection of two lists
Python
0 vote284 views1 answer
Flask wtforms multiple select
Python Flask