/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 vote100 views1 answer
How to use django-rest-framework-datatables
Python
16 votes117 views5 answers
Primes in python
Python
20 votes122 views3 answers
Convert a number column into datetime pandas
Python
0 vote140 views1 answer
How to get the current url path in django template
Python Django
0 vote102 views1 answer
Cufflink install python jupyter
Python
2 votes124 views3 answers
Find difference between two pandas dataframes
Python
0 vote99 views1 answer
Applymap(lambda x: x.encode('unicode_escape'). decode('utf-8') if isinstance(x, str) else x)
Python
2 votes105 views2 answers
Standard module
Python
2 votes99 views1 answer
W=how to tell if decimal in python
Python
-1 vote52 views2 answers
Model deployment with flask
Python