Consolidating code

[jhartc]

I have the following code:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23

# Load the Pandas libraries with alias 'pd' import pandas as pd import numpy as np # Read data from file 'filename.csv' # (in the same directory that your python process is based) # Control delimiters, rows, column names with read_csv (see later) df = pd.read_csv("../example.csv", parse_dates=['DateTime']) # Preview the first 5 lines of the loaded data       df = df.assign(Burned = df['Quantity']) df.loc[df['To'] != '0x0000000000000000000000000000000000000000', 'Burned'] = 0.0 # OR:   df['cum_sum'] = df['Burned'].cumsum() df['percent_burned'] = df['cum_sum']/df['Quantity'].max()*100.0   per_day           =    df.groupby(df['DateTime'].dt.date)['Burned'].count().reset_index(name='Trx') per_day_burned    =    df.groupby(df['DateTime'].dt.date)['Burned'].sum().reset_index(name='Burned')   per_day['Burned'] = per_day_burned['Burned'] per_day['Burned_per_trx']=per_day['Burned']/per_day['Trx']

Clearly my code needs some work. You can see that I want to create a dataFrame called per_day that groups the transactions in df by date so that instead of getting thousands of transaction a day, it just shows the total number of transactions in a day.

You can see that I create per_day_burned to get another dataFrame before combining it into the per_day dataFrame. Is there a way to consolidate per_day and per_day_burned into a single line of code? Or how can I directly have per_day_burned be part of per_day? I dont even want the per_day_burned dataFrame. I just want it to be a class in per_day (like the 3rd column). How do I do this?

Doing something like per_day['Burned']=df.groupby(df['DateTime'].dt.date)['Burned'].sum().reset_index(name='Burned') because it sends to arguments to a dataFrame expecting 1 argument.



The second question I have is this:

The code:

1	per_day           =    df.groupby(df['DateTime'].dt.date)['Burned'].count().reset_index(name='Trx')

gives the total sum of transactions on a given day. How do I exlcude the transactions from being included if 'Burned' = 0 for that transaction?