Python - Is there a way to output results to pandas DF

Question

I have the following sample DF:

Car Model	Sales
Mercedes Benz
Audi	100000
Renault	50000

I have 2 calculations

Calculate the number of blank rows in the sales column

missingSalesInfo = DF['Sales'].isnull().sum()

missingSalesInfo = ("Number of missing values: ",missingSalesInfo)
Calculate the total car sales

totalSales = DF['Sales'].sum()

totalSales = ("Total car sales: ",totalSales)

What I want to do is create a new DF, lets call it DF2 to store the above results. See example below

DF2

Description	Results
Number of missing values	1
Total car sales	150000

jezrael · Accepted Answer · 2021-11-11 08:39:44Z

1

Use Series.agg with aggregate functions in dictionary, convert to integers and convert to DataFrame from Series by Series.reset_index, for set new columns names is used DataFrame.set_axis:

df2 = (df['Sales'].agg({'Number of missing values': lambda x: x.isna().sum(),
                        'Total car sales': 'sum'})
                  .astype(int)
                  .reset_index()
                  .set_axis(['Description','Results'], axis=1)
                 )
print (df2)
                Description  Results
0  Number of missing values        1
1           Total car sales   150000

Alternative:

df2 = (df['Sales'].agg({'Number of missing values': lambda x: x.isna().sum(),
                       'Total car sales': 'sum'})
                  .astype(int)
                  .reset_index())

df2.columns = ['Description','Results']

edited Nov 11, 2021 at 8:39

answered Nov 11, 2021 at 8:31

jezrael

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

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

Comments

ChrisOram · Accepted Answer · 2021-11-11 08:31:15Z

0

That's just a question of how to create a DataFrame. You can do that in a few ways, but here it's done with dictionary:

df2 = pd.DataFrame({
    'Description': ['Number of missing values', 'Total car sales'], 
    'Results': [DF['Sales'].isnull().sum(), DF['Sales'].sum()]
})

answered Nov 11, 2021 at 8:31

ChrisOram

1,4742 gold badges9 silver badges25 bronze badges

Comments

Gedas Miksenas · Accepted Answer · 2021-11-11 08:28:50Z

0

Several ways to do that. Here's a simple way.

df_2 = pd.DataFrame()
df_2['Number of missing values'] =  DF['Sales'].isnull().sum()
df_2['Total car sales'] =  DF['Sales'].sum()`

answered Nov 11, 2021 at 8:28

Gedas Miksenas

1,07910 silver badges18 bronze badges

Collectives™ on Stack Overflow

Python - Is there a way to output results to pandas DF

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related