python pandas dataframe indexing

Question

I have a data frame

df = pd.DataFrame(carData)
df.column['models']
#df.ffill() This is where i need to fill the amount of columns i want to add with previous value

The data looks something like

          models
1         honda
2         ford
3         chevy

I want to add an index but keep it numerical up to a certain number and forward fill the models column to the last value. so for example the dataset above has 3 entries, I want to add an have a total of 5 entries it should look something like

          models
1         honda
2         ford
3         chevy
4         chevy
5         chevy

jezrael · Accepted Answer · 2019-01-21 08:03:15Z

2

Using df.reindex() and df.ffill()

N= 5
df.reindex(range(N)).ffill()

    models
0   honda
1   ford
2   chevy
3   chevy
4   chevy

edited Jan 21, 2019 at 8:03

jezrael

868k102 gold badges1.4k silver badges1.3k bronze badges

answered Jan 21, 2019 at 7:12

anky

75.3k11 gold badges46 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

jezrael · Accepted Answer · 2019-01-21 07:16:55Z

2

Use reindex with method='ffill' or add ffill:

N = 5
df = df.reindex(np.arange(1, N + 1), method='ffill')
#alternative
#df = df.reindex(np.arange(1, N + 1)).ffill()
print (df)
  models
1  honda
2   ford
3  chevy
4  chevy
5  chevy

If default RangeIndex:

df = df.reset_index(drop=True)

N = 5
df = df.reindex(np.arange(N), method='ffill')
#alternative
#df = df.reindex(np.arange(N)).ffill()
print (df)
  models
0  honda
1   ford
2  chevy
3  chevy
4  chevy

edited Jan 21, 2019 at 7:16

answered Jan 21, 2019 at 7:11

jezrael

868k102 gold badges1.4k silver badges1.3k bronze badges

Collectives™ on Stack Overflow

python pandas dataframe indexing

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related