/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 vote180 views1 answer
Python count variable and put the count in a column of data frame
Python
5 votes205 views3 answers
How to run flask in port 80
Python
0 vote142 views1 answer
Repeat a condition n times one by one python
Python
0 vote163 views1 answer
Write cell output to file jupyter colab
Python
2 votes213 views2 answers
Django request.data
Python Django
0 vote230 views1 answer
ValueError: Could not load "" Reason: "broken data stream when reading image file"
Python
-2 votes161 views1 answer
Stats.norm.cdf(2,loc=mean, scale=std_dev)
Python
5 votes158 views1 answer
Getpass
Python
0 vote192 views1 answer
Drop specific column in data
Python
13 votes149 views1 answer
Python str contains word
Python