/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 vote204 views2 answers
Check if user has manage messages discord.py
Python
1 vote190 views1 answer
Python return specific elements from list
Python
0 vote264 views1 answer
Python install minio
Python
0 vote184 views1 answer
Concat and Append DFs Python
Python
5 votes203 views2 answers
String to binary python
Python
0 vote187 views1 answer
Making Dataframe with named column
Python
0 vote191 views1 answer
Use of OfficeApi
Python
1 vote199 views1 answer
Python everything after last slash
Python
0 vote251 views1 answer
Take substring of every element in dataframe
Python
0 vote248 views1 answer
Using default as none in django mdoels
Python Django