/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 vote183 views1 answer
NameError: name 'accuracy_score' is not defined
Python
0 vote183 views1 answer
Python print all variables in memory
Python
1 vote171 views1 answer
How to pass data between views django
Python
3 votes151 views1 answer
Update all modules python in cmd
Python
0 vote169 views1 answer
Get the values of your aws tags from ec2 instance
Python
0 vote168 views1 answer
Missingno python
Python
2 votes164 views1 answer
Python read excel set index
Python
0 vote167 views1 answer
Violin Plot Seaborn
Python
13 votes180 views6 answers
Threading in python
Python
8 votes180 views1 answer
Python ubuntu check if a key is pressed
Python