In [2]:

    

import pandas as pd


    

In [3]:

    

df = pd.read_excel('VVER_RBMK_BWR_Real_Data.xlsx','Sheet1')


    

In [7]:

    

df.drop('burnup', axis=1, inplace=True)


    

In [9]:

    

low_values = []
high_values = []
for ix, row in df.iterrows():
    if (row['pu238/pu239'] > .02 or row['pu240/pu239'] > .3 or
        row['pu241/pu239'] > .05 or row['pu242/pu239'] > .05):
        high_values.append(row)
    else:
        low_values.append(row)


    

In [10]:

    

df_low = pd.DataFrame(low_values)
df_high = pd.DataFrame(high_values)


    

In [13]:

    

df_low.to_excel('Low_real_data.xlsx', 'Sheet1')


    

In [14]:

    

df_high.to_excel('High_real_data.xlsx', 'Sheet1')


    

In [15]:

    

!pwd


    

    




/Users/colingerber/Documents/GSR Work/Programing/Cluster_Analysis/Current_Version/Nuclear_Forensics_Cluster_Analysis/Regression_Analysis/Testing

In [ ]: