/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 vote120 views1 answer
Python non public method
Python
0 vote150 views1 answer
Https://practice.geeksforgeeks.org/problems/coin-change2448/1
Python
0 vote112 views1 answer
Transcript with timestamps in python
Python
0 vote107 views1 answer
Tkinter how to connect keyboard key to button
Python
0 vote110 views2 answers
Pandas sub columns
Python
0 vote117 views2 answers
Load specific columns dataframe
Python
2 votes116 views1 answer
Django register models
Python
0 vote113 views1 answer
Nlargest of each group
Python
0 vote118 views1 answer
Python multiline code dot
Python
14 votes119 views3 answers
Matplotlib make bigger sublots
Python