Python dataframe append row with default value

Question

I am trying to append a row to a DataFrame in which the entire row should take on a default value. I see posts on adding a column with default values, but how do I append a row with default values?

apparently related: stackoverflow.com/questions/36366036/… — starball
– starball ♦, Commented May 3, 2023 at 9:42

ak_slick · Accepted Answer · 2020-02-06 17:14:50Z

2

When you say append I think you mean add a new row to the bottom of a dataframe with a default value like this.

import pandas as pd
import numpy as np

df = pd.DataFrame({0: {0: 'March', 1: 2019, 2: 'A'},
 1: {0: 'April', 1: 2019, 2: 'E'},
 2: {0: 'May', 1: 2019, 2: 'F'}})

# where 1 is the default value
df.loc[3,:] = 1

Yeilds:

    0       1       2
0   March   April   May
1   2019    2019    2019
2   A       E       F
3   1       1       1

answered Feb 6, 2020 at 17:14

ak_slick

1,0167 silver badges21 bronze badges

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

Comments

juuubbb · Accepted Answer · 2020-02-06 17:17:35Z

0

Create a single line dataframe and then use DataFrame.append():

df_to_append = pd.DataFrame([0, 0], columns=['column1', 'column2'])
your_df.append(df_to_append)

Checkout https://www.geeksforgeeks.org/python-pandas-dataframe-append/ For more information provide your piece of code

answered Feb 6, 2020 at 17:17

juuubbb

1791 gold badge7 silver badges16 bronze badges

Collectives™ on Stack Overflow

Python dataframe append row with default value

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related