/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 vote258 views1 answer
Run for loop inside pdb
Python
1 vote244 views1 answer
Animations text terminal python
Python
0 vote260 views1 answer
Logistic regresion heart disease python
Python
0 vote301 views1 answer
Request streaming python
Python
13 votes269 views3 answers
Python program to calculate factorial of a number.
Python
0 vote287 views1 answer
Add row in db django
Python Django
24 votes223 views17 answers
Palindrome in python
Python
4 votes285 views2 answers
Using tqdm in for loop
Python
0 vote238 views1 answer
Discord.py read custom status
Python
1 vote289 views1 answer
How to make pyautogui faster
Python