/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 vote271 views1 answer
Python local date time
Python
39 votes110 views2 answers
String to list of characters python
Python
1 vote103 views1 answer
Hex to binary python3
Python
0 vote101 views1 answer
How to uninstall python-dotenv
Python
114 votes101 views6 answers
Python print to file
Python
31 votes64 views1 answer
Sort_values pandas series
Python
3 votes107 views1 answer
Io.UnsupportedOperation: not readable
Python
0 vote96 views1 answer
Get next multiple of a number
Python
0 vote105 views1 answer
Make_interp_spline
Python
3 votes103 views2 answers
Update_or_create django
Python