/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 vote189 views1 answer
Dividing counter object in python
Python
24 votes455 views6 answers
Static files in django
Python Django
0 vote185 views1 answer
Check pd.NaT python
Python
4 votes248 views1 answer
Plt add axis name
Python
5 votes177 views5 answers
12 hr to 24 hour time conversion python
Python
0 vote205 views2 answers
Wireframes and Surface Plots
Python
5 votes198 views3 answers
Text to binary python
Python
0 vote240 views1 answer
Efficiently count zero elements in numpy array?
Python
2 votes181 views2 answers
Pandas series to dataframe index as column
Python
191 votes278 views6 answers
Pip upgrade python
Python