In [1]:
import pandas as pd
In [2]:
doosan_hb_df = pd.read_csv("basic/doosan_hb_15.csv")
hanhwa_hb_df = pd.read_csv("basic/hanhwa_hb_15.csv")
KIA_hb_df = pd.read_csv("basic/KIA_hb_15.csv")
KT_hb_df = pd.read_csv("basic/KT_hb_15.csv")
LG_hb_df = pd.read_csv("basic/LG_hb_15.csv")
lotte_hb_df = pd.read_csv("basic/lotte_hb_15.csv")
NC_hb_df = pd.read_csv("basic/NC_hb_15.csv")
nexen_hb_df = pd.read_csv("basic/nexen_hb_15.csv")
samsung_hb_df = pd.read_csv("basic/samsung_hb_15.csv")
SK_hb_df = pd.read_csv("basic/SK_hb_15.csv")
In [3]:
doosan_hd_df = pd.read_csv("detail/doosan_hd_15.csv")
hanhwa_hd_df = pd.read_csv("detail/hanhwa_hd_15.csv")
KIA_hd_df = pd.read_csv("detail/KIA_hd_15.csv")
KT_hd_df = pd.read_csv("detail/KT_hd_15.csv")
LG_hd_df = pd.read_csv("detail/LG_hd_15.csv")
lotte_hd_df = pd.read_csv("detail/lotte_hd_15.csv")
NC_hd_df = pd.read_csv("detail/NC_hd_15.csv")
nexen_hd_df = pd.read_csv("detail/nexen_hd_15.csv")
samsung_hd_df = pd.read_csv("detail/samsung_hd_15.csv")
SK_hd_df = pd.read_csv("detail/SK_hd_15.csv")
In [6]:
doosan_df = doosan_hb_df.merge(doosan_hd_df, left_on="name",right_on="name")[["name", "team_x", "AVG_x", "G", "PA", "AB", "R", "H", "2B", "3B", "HR", "TB", "RBI", "SAC", "SF", "XBH", "GO", "AO", "GO/AO", "GW_RBI", "BB/K", "P/PA", "ISOP", "XR", "GPA"]]
hanhwa_df = hanhwa_hb_df.merge(hanhwa_hd_df, left_on="name",right_on="name")[["name", "team_x", "AVG_x", "G", "PA", "AB", "R", "H", "2B", "3B", "HR", "TB", "RBI", "SAC", "SF", "XBH", "GO", "AO", "GO/AO", "GW_RBI", "BB/K", "P/PA", "ISOP", "XR", "GPA"]]
KIA_df = KIA_hb_df.merge(KIA_hd_df, left_on="name",right_on="name")[["name", "team_x", "AVG_x", "G", "PA", "AB", "R", "H", "2B", "3B", "HR", "TB", "RBI", "SAC", "SF", "XBH", "GO", "AO", "GO/AO", "GW_RBI", "BB/K", "P/PA", "ISOP", "XR", "GPA"]]
KT_df = KT_hb_df.merge(KT_hd_df, left_on="name",right_on="name")[["name", "team_x", "AVG_x", "G", "PA", "AB", "R", "H", "2B", "3B", "HR", "TB", "RBI", "SAC", "SF", "XBH", "GO", "AO", "GO/AO", "GW_RBI", "BB/K", "P/PA", "ISOP", "XR", "GPA"]]
LG_df = LG_hb_df.merge(LG_hd_df, left_on="name",right_on="name")[["name", "team_x", "AVG_x", "G", "PA", "AB", "R", "H", "2B", "3B", "HR", "TB", "RBI", "SAC", "SF", "XBH", "GO", "AO", "GO/AO", "GW_RBI", "BB/K", "P/PA", "ISOP", "XR", "GPA"]]
lotte_df = lotte_hb_df.merge(lotte_hd_df, left_on="name",right_on="name")[["name", "team_x", "AVG_x", "G", "PA", "AB", "R", "H", "2B", "3B", "HR", "TB", "RBI", "SAC", "SF", "XBH", "GO", "AO", "GO/AO", "GW_RBI", "BB/K", "P/PA", "ISOP", "XR", "GPA"]]
NC_df = NC_hb_df.merge(NC_hd_df, left_on="name",right_on="name")[["name", "team_x", "AVG_x", "G", "PA", "AB", "R", "H", "2B", "3B", "HR", "TB", "RBI", "SAC", "SF", "XBH", "GO", "AO", "GO/AO", "GW_RBI", "BB/K", "P/PA", "ISOP", "XR", "GPA"]]
nexen_df = nexen_hb_df.merge(nexen_hd_df, left_on="name",right_on="name")[["name", "team_x", "AVG_x", "G", "PA", "AB", "R", "H", "2B", "3B", "HR", "TB", "RBI", "SAC", "SF", "XBH", "GO", "AO", "GO/AO", "GW_RBI", "BB/K", "P/PA", "ISOP", "XR", "GPA"]]
samsung_df = samsung_hb_df.merge(samsung_hd_df, left_on="name",right_on="name")[["name", "team_x", "AVG_x", "G", "PA", "AB", "R", "H", "2B", "3B", "HR", "TB", "RBI", "SAC", "SF", "XBH", "GO", "AO", "GO/AO", "GW_RBI", "BB/K", "P/PA", "ISOP", "XR", "GPA"]]
SK_df = SK_hb_df.merge(SK_hd_df, left_on="name",right_on="name")[["name", "team_x", "AVG_x", "G", "PA", "AB", "R", "H", "2B", "3B", "HR", "TB", "RBI", "SAC", "SF", "XBH", "GO", "AO", "GO/AO", "GW_RBI", "BB/K", "P/PA", "ISOP", "XR", "GPA"]]
In [7]:
doosan_df = doosan_df.rename(columns={"team_x":"team"})
hanhwa_df = hanhwa_df.rename(columns={"team_x":"team"})
KIA_df = KIA_df.rename(columns={"team_x":"team"})
KT_df = KT_df.rename(columns={"team_x":"team"})
LG_df = LG_df.rename(columns={"team_x":"team"})
lotte_df = lotte_df.rename(columns={"team_x":"team"})
NC_df = NC_df.rename(columns={"team_x":"team"})
nexen_df = nexen_df.rename(columns={"team_x":"team"})
samsung_df = samsung_df.rename(columns={"team_x":"team"})
SK_df = SK_df.rename(columns={"team_x":"team"})
In [8]:
doosan_df = doosan_df.rename(columns={"AVG_x":"AVG"})
hanhwa_df = hanhwa_df.rename(columns={"AVG_x":"AVG"})
KIA_df = KIA_df.rename(columns={"AVG_x":"AVG"})
KT_df = KT_df.rename(columns={"AVG_x":"AVG"})
LG_df = LG_df.rename(columns={"AVG_x":"AVG"})
lotte_df = lotte_df.rename(columns={"AVG_x":"AVG"})
NC_df = NC_df.rename(columns={"AVG_x":"AVG"})
nexen_df = nexen_df.rename(columns={"AVG_x":"AVG"})
samsung_df = samsung_df.rename(columns={"AVG_x":"AVG"})
SK_df = SK_df.rename(columns={"AVG_x":"AVG"})
In [9]:
doosan_df.to_csv("doosan_hitter.csv",encoding='utf-8')
hanhwa_df.to_csv("hanhwa_hitter.csv",encoding='utf-8')
KIA_df.to_csv("KIA_hitter.csv",encoding='utf-8')
KT_df.to_csv("KT_hitter.csv",encoding='utf-8')
LG_df.to_csv("LG_hitter.csv",encoding='utf-8')
lotte_df.to_csv("lotte_hitter.csv",encoding='utf-8')
NC_df.to_csv("NC_hitter.csv",encoding='utf-8')
nexen_df.to_csv("nexen_hitter.csv",encoding='utf-8')
samsung_df.to_csv("samsung_hitter.csv",encoding='utf-8')
SK_df.to_csv("SK_hitter.csv",encoding='utf-8')
In [11]:
hitter_df = pd.concat([doosan_df, hanhwa_df, KIA_df, KT_df, LG_df, lotte_df, NC_df, nexen_df, samsung_df, SK_df]).reset_index(drop=True)
In [13]:
hitter_df.to_csv("hitter_final.csv",encoding='utf-8')
In [14]:
hitter_df
Out[14]:
In [ ]: