/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 vote394 views1 answer
Get a list of open applications python
Python
0 vote411 views1 answer
Json filter python
Python
0 vote345 views2 answers
IPTC text classification example
Python
1 vote335 views1 answer
Pytho list items to int
Python
1 vote356 views1 answer
Skip element in list comprehension
Python
0 vote369 views1 answer
Python : read all the lines of the text file and return them as a list of strings (use of 'with open')
Python
1 vote359 views1 answer
Df.fillna(-999,inplace=True)
Python
0 vote367 views1 answer
Python timedelta get days with fraction
Python
0 vote432 views1 answer
: UserWarning: Matplotlib is currently using module://matplotlib_inline.backend_inline, which is a non-GUI backend,
Python
1 vote331 views2 answers
Make python3 as default in linux
Python