# ---
# jupyter:
#   jupytext:
#     text_representation:
#       extension: .py
#       format_name: light
#       format_version: '1.5'
#       jupytext_version: 1.14.4
#   kernelspec:
#     display_name: Python 3
#     language: python
#     name: python3
# ---

import pandas as pd

s1 = pd.read_excel('v86_fold_6_Output.xlsx')
s2 = pd.read_excel('v59_fold_3_Output.xlsx')
s3 = pd.read_excel('v86_fold_5_Output.xlsx')
s4 = pd.read_excel('v85_fold_6_Output.xlsx')
s5 = pd.read_excel('v54_fold_7_Output.xlsx')
s6 = pd.read_excel('v72_fold_6_Output.xlsx')

s1['Views'] = s1['Views']*.35 + s2['Views']*.05 + s3['Views']*.20 + s4['Views']*.05 + s5['Views']*.25 + s6['Views']*0.10

s1.head()

s1.to_excel('ensemble.xlsx', index=False)

s1.head()

StarcoderdataJupyterScriptsDedupFiltered