how do I insert a row for under a specific cell value

Question

I have a dataframe below and I want to insert a new row under shop with values, how do I do that ?

values = 0.2, park, false


df1 = 
   number    variable values
1     NaN        bank   True
2     3.0        shop  False
3     0.5      market   True
4     NaN  government   True
5     1.0       hotel   true

Does this answer your question? [Appending a list or series to a pandas DataFrame as a row?](https://stackoverflow.com/questions/26309962/appending-a-list-or-series-to-a-pandas-dataframe-as-a-row) — Yevhen Kuzmovych, Nov 16 '22 at 11:16
I would like it to be added as a row under shop not at the end of the dataframe, variable = shop — Jimmy3421, Nov 16 '22 at 11:25

score 1 · Accepted Answer · answered Nov 16 '22 at 13:10

You can try:

import pandas as pd

df = pd.DataFrame({'number': [float('NaN'), 3.0, 0.5, float('NaN'), 1.0], 'variable':['bank','shop','market','government','hotel'], 'values':[True, False, True, True, True]})
print("----- ORIGINAL ------")
print(df)
shop_index = df.reset_index()['variable'].tolist().index('shop') 
insert = pd.DataFrame({"number": 0.2, "variable": "park", "values": False}, index=[shop_index+1])

df2 = pd.concat([df.iloc[:shop_index+1], insert, df.iloc[shop_index+1:]]).reset_index(drop=True)
print("----- AFTER INSERT ------")
print(df2)

Output:

----- ORIGINAL ------
   number    variable  values
0     NaN        bank    True
1     3.0        shop   False
2     0.5      market    True
3     NaN  government    True
4     1.0       hotel    True


----- AFTER INSERT ------
   number    variable  values
0     NaN        bank    True
1     3.0        shop   False
2     0.2        park   False
3     0.5      market    True
4     NaN  government    True
5     1.0       hotel    True

Thanks, how would I put this into a loop, so I can add shop to a much larger dataframe, this was just an example. — Jimmy3421, Nov 17 '22 at 10:01
you can add for/while loop. If answer is correct, please accept the same. — Harsha Biyani, Nov 17 '22 at 10:33

score 0 · Answer 2 · answered Nov 16 '22 at 11:23

0

Using indices, you can specify a row to modify using df.loc[] To input

To append to the last row in the current dataframe, get the last index using df.loc[-1], add a new index and sort them.

In your case:

df.loc[-1] = values
df.index = df.index + 1 
df = df.sort_index()

answered Nov 16 '22 at 11:23

Sondre Gjengedal-Eide

66
1
4

I want to insert a row below a specific value in this case where variable = shop – Jimmy3421 Nov 16 '22 at 11:29

how do I insert a row for under a specific cell value

2 Answers2