Splitting Raw Data into districts

Splitting Raw Data into districts#

Data provided by Fireweed corresponds to a district containing 3 deposits :

  • Tom Zone

  • Boundary Zone

  • Jason & End Zone

Raw Data will be loaded, splitted into the three deposits and exported as csv files for collar/survey/assay.

import pandas as pd

CSV Loading#

assay = pd.read_csv("../data/MPA_Samples_BD_20240227.csv")
collar = pd.read_csv("../data/MPA_Collar_20240227.csv")
survey = pd.read_csv("../data/MPA_Survey_20240227.csv")
interp = pd.read_csv("../data/MPA_Interp_20240227.csv")

collar = collar[collar['Year'] < 2018]

interp.rename(columns={"holeid": "HoleID", "from": "From_m", "to": "To_m"}, inplace=True)

Split Collar into the 3 Main Prospects#

collar_boundary = collar[collar["Property"].str.contains("NIDD")]
collar_tom = collar[collar["Property"].str.contains("TOM")]
collar_json_end = collar[collar["Property"].str.contains("JASON")]

collar_boundary.to_csv("../data/collar_boundary.csv", index=False)
collar_tom.to_csv("../data/collar_tom.csv", index=False)
collar_json_end.to_csv("../data/collar_json_end.csv", index=False)

Split Survey into the 3 Main Prospects#

survey_boundary = survey[survey['HoleID'].isin(collar_boundary['HoleID'])]
survey_tom = survey[survey['HoleID'].isin(collar_tom['HoleID'])]
survey_json_end = survey[survey['HoleID'].isin(collar_json_end['HoleID'])]

survey_boundary.to_csv("../data/survey_boundary.csv", index=False)
survey_tom.to_csv("../data/survey_tom.csv", index=False)
survey_json_end.to_csv("../data/survey_json_end.csv", index=False)

Split Assay into the 3 Main Prospects#

assay_boundary = assay[assay['HoleID'].isin(collar_boundary['HoleID'])]
assay_tom = assay[assay['HoleID'].isin(collar_tom['HoleID'])]
assay_json_end = assay[assay['HoleID'].isin(collar_json_end['HoleID'])]

assay_boundary.to_csv("../data/assay_boundary.csv", index=False)
assay_tom.to_csv("../data/assay_tom.csv", index=False)
assay_json_end.to_csv("../data/assay_json_end.csv", index=False)

Split Interp into the 3 Main Prospects#

interp_boundary = interp[interp['HoleID'].isin(collar_boundary['HoleID'])]
interp_tom = interp[interp['HoleID'].isin(collar_tom['HoleID'])]
interp_json_end = interp[interp['HoleID'].isin(collar_json_end['HoleID'])]

interp_boundary.to_csv("../data/interp_boundary.csv", index=False)
interp_tom.to_csv("../data/interp_tom.csv", index=False)
interp_json_end.to_csv("../data/interp_json_end.csv", index=False)
Contents