text_plain_output_1.png
import pandas as pd

df = pd.read_excel('../input/volve-production-data/Volve production data.xlsx')

df.isna().sum()

well_prod = df.groupby('NPD_WELL_BORE_NAME')['BORE_OIL_VOL'].sum()
well_prod

well_prod_g = df.groupby('NPD_WELL_BORE_NAME')['BORE_GAS_VOL'].sum()
well_prod_g

well_prod_w = df.groupby('NPD_WELL_BORE_NAME')['BORE_WAT_VOL'].sum()
well_prod_w

df.hist(figsize=(18, 18))