File size: 533 Bytes
2e37891 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
import pandas as pd
import numpy as np
import streamlit as st
@st.cache_data
def load_data():
final = pd.read_excel("data/최종.xlsx")
final["공연벡터"] = final["공연벡터"].apply(eval)
final["공연장벡터"] = final["공연장벡터"].apply(eval)
facility = pd.read_excel("data/공연시설DB.xlsx")
concert = pd.read_excel("data/내한공연DB.xlsx")
df = pd.merge(final, facility, on="공연시설ID", how="left")
df = pd.merge(df, concert, on="공연ID(mt20Id)", how="left")
return df
|