/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 vote349 views2 answers
{:.1%} print one decimal pandas
Python
0 vote364 views1 answer
Python garbaze collection
Python
0 vote338 views1 answer
Python reading into a text file and diplaying items in a user friendly manner
Python
8 votes362 views3 answers
Python is integer string
Python
3 votes339 views1 answer
Static root django
Python Django
0 vote339 views1 answer
Pandas series remove element by index
Python
5 votes316 views2 answers
Jupyter convert cell to text
Python
0 vote390 views1 answer
Whitelist the ip address django
Python Django
0 vote374 views1 answer
Http response template
Python
0 vote372 views1 answer
Python float till 2 decimal places
Python