<jupyter_start><jupyter_text>Stop, meta time ![title](well_log.jpg)<jupyter_code>import pandas as pd
from keras.utils import np_utils
import numpy as np
houmath = pd.read_csv("../HouMath/Prediction6.csv", delimiter=",")
houmath_f1 = 0.63
houmath_facies = np_utils.to_categorical(houmath["Facies"]-1, nb_classes=9)


ar4 = pd.read_csv("../ar4/ar4_predicted_facies_submission002.csv", delimiter=",")
ar4_f1 = 0.606
ar4_facies = np_utils.to_categorical(ar4["Facies"]-1, nb_classes=9)

bestagini = pd.read_csv("../ispl/well_data_with_facies_try02.csv", delimiter=",")
bestagini_f1 = 0.604
bestagini_facies = np_utils.to_categorical(bestagini["Facies"]-1, nb_classes=9)

birdteam =  pd.read_csv("../Bird_Team/XmasPreds_4.csv", delimiter=",")
birdteam_f1 = 0.598
birdteam_facies = np_utils.to_categorical(birdteam["Facies"]-1, nb_classes=9)

sum_f1 = ar4_f1+bestagini_f1+houmath_f1+birdteam_f1
print( houmath.head())
print( ar4.head())
print( bestagini.head())
print( birdteam.head())
meta_facies = (bestagini_f1*bestagini_facies + ar4_f1*ar4_facies 
               + birdteam_f1*bestagini_facies + houmath_f1*houmath_facies)/(sum_f1)
print(meta_facies)
metasubmission = np.argmax(meta_facies, axis=1) + 1
print (metasubmission)
test_data = pd.read_csv("../validation_data_nofacies.csv", delimiter=",")
print(test_data.head())
test_data["Facies"] = metasubmission

test_data.to_csv("the_meta_submission.csv")

print(test_data.head())<jupyter_output>Formation Well Name   Depth      GR  ILD_log10  DeltaPHI  PHIND     PE  \
0     A1 SH    STUART  2808.0  66.276      0.630       3.3  10.65  3.591   
1     A1 SH    STUART  2808.5  77.252      0.585       6.5  11.95  3.341   
2     A1 SH    STUART  2809.0  82.899      0.566       9.4  13.60  3.064   
3     A1 SH    STUART  2809.5  80.671      0.593       9.5  13.25  2.977   
4     A1 SH    STUART  2810.0  75.971      0.638       8.7  12.35  3.020   

   NM_M  RELPOS  
0     1   1.000  
1     1   0.978  
2     1   0.956  
3     1   0.933  
4     1   0.911  
  Formation Well Name   Depth      GR  ILD_log10  DeltaPHI  PHIND     PE  \
0     A1 SH    STUART  2808.0  66.276      0.630       3.3  10.65  3.591   
1     A1 SH    STUART  2808.5  77.252      0.585       6.5  11.95  3.341   
2     A1 SH    STUART  2809.0  82.899      0.566       9.4  13.60  3.064   
3     A1 SH    STUART  2809.5  80.671      0.593       9.5  13.25  2.977   
4     A1 SH    STUART  2810.0  75.971      0.638       [...]
{'fraction_non_alphanumeric': 0.11651676206050696, 'fraction_numerical': 0.13900245298446443, 'mean_word_length': 2.4957142857142856, 'pattern_counts': {'":': 0, '<': 4, '<?xml version=': 0, '>': 4, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'chain_length': '1', 'dir': 'jupyter-structured-clean-dedup', 'id': '291210', 'license': 'Apache-2.0', 'n_tokens_mistral': 1212, 'n_tokens_neox': 1066, 'n_words': 208, 'path': 'LA_TEAM_FRESH/So Meta.ipynb', 'repo_name': 'Arnoldsynchron/2016-ml-contest', 'size': '2446'}