Data Manipulation using Pandas

Question

I want to copy a value in a dataframe uptil next NaN.

Here is the dataframe I have:

               Description
0              091SS16 GASOILA THREAD SEALANT
1              NaN
2              NaN
3              NaN
4              NaN
5              NaN
6              NaN
7              3M07447 SCOTCH BRITE PAD
8              NaN
9              NaN
10             NaN
11             NaN
12             NaN
13             NaN
14             NaN
15             600B 6" BUNA-N GASKET

And this is my expected output:

Description
0              091SS16 GASOILA THREAD SEALANT
1              091SS16 GASOILA THREAD SEALANT
2              091SS16 GASOILA THREAD SEALANT
3              091SS16 GASOILA THREAD SEALANT
4              091SS16 GASOILA THREAD SEALANT
5              091SS16 GASOILA THREAD SEALANT
6              091SS16 GASOILA THREAD SEALANT
7              3M07447 SCOTCH BRITE PAD
8              3M07447 SCOTCH BRITE PAD
9              3M07447 SCOTCH BRITE PAD
10             3M07447 SCOTCH BRITE PAD
11             3M07447 SCOTCH BRITE PAD
12             3M07447 SCOTCH BRITE PAD
13             3M07447 SCOTCH BRITE PAD
14             3M07447 SCOTCH BRITE PAD
15             600B 6" BUNA-N GASKET

Kindly help. Thank you!

`df.fillna` using `ffill` as the method – G. Anderson Feb 01 '19 at 19:11 — G. Anderson, Feb 01 '19 at 19:11
Damn, that's as easy as it gets. Thank you. – Venkatesh Malhotra Feb 01 '19 at 19:13 — Venkatesh Malhotra, Feb 01 '19 at 19:13

score 1 · Accepted Answer · answered Feb 01 '19 at 19:12

1

You need fillna with ffill:

df.fillna(ffill)

answered Feb 01 '19 at 19:12

Sociopath

13,068
19
47
75

1

df.ffill(inplace=True) – BENY Feb 01 '19 at 19:53

score 0 · Answer 2 · answered Feb 01 '19 at 19:33

df.fillna(value = 'anyvalue') will fill the nulls with a specified value

df.fillna(method = 'ffill')

ffill lets to forward fill value till the next not null value

There is also

bfill - lets you backfill value till the not null value before it

nearest - fills Nan with nearest non null value

df.fillna(method = 'ffill', inplace = True) inplace changes the value of your df inplace

Data Manipulation using Pandas

2 Answers2