/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 vote287 views1 answer
Boolean meaning in python
Python
0 vote318 views1 answer
Print numbers from 1 to 100 in python
Python
2 votes293 views3 answers
Torch.stack example
Python
0 vote328 views1 answer
Python how to get html code from url
Python
0 vote310 views1 answer
Selenium open inspect
Python
6 votes300 views4 answers
Get channel from id discord.py
Python
0 vote282 views1 answer
Reg.fit(x_train, y_train) TypeError: fit() missing 1 required positional argument: 'y'
Python
4 votes349 views2 answers
Authentication views django
Python Django
0 vote311 views1 answer
Formate a phonenumber in phonenumber package with PhoneNumberFormat
Python
0 vote276 views2 answers
Generate random string with special characters and numbers in python
Python