To dos

1) Integrate all the csv

a. pd.concat ( add afterwards DF below the existing DF)

b. reset_index ( delete existing index of each row, and make new index, reflecting renewed index as a whole)

import pandas as pd

## 1. DEF
DF_etc = pd.read_csv("C:/Users/user/Desktop/Web_Study/Dance_Match/Def_Dance.csv", index_col = 0 ,sep = ",", encoding= "euc-kr", dtype ="unicode")

# print(DF_etc)

## 2. JJ 
JJ = pd.read_csv("C:/Users/user/Desktop/Web_Study/Dance_Match/JJ.csv", encoding = "euc-kr")

## 3. We_Flex
We_Flex = pd.read_csv("C:/Users/user/Desktop/Web_Study/Dance_Match/WeFlex.csv", encoding = "euc-kr")

## 4. Soul
Soul = pd.read_csv("C:/Users/user/Desktop/Web_Study/Dance_Match/Soul.csv", encoding = "utf-8")

Dance_Total_DF = pd.concat([DF_etc, JJ, We_Flex, Soul])

Dance_Total_DF = Dance_Total_DF.reset_index(drop = True)

Dance_Total_DF.to_csv("C:/Users/user/Desktop/Web_Study/Dance_Match/Dance_Total.csv", mode = "w", encoding = "utf-8-sig")

2) Move Excel to DB

코드를 입력from pymongo import MongoClient
import csv

# DB connectivity
client = MongoClient('localhost', 27017)
# dbsparta 라는 곳에 넣는다
dbsparta = client.dbsparta 
collection = dbsparta.collection 

# Function to parse csv to dictionary
def csv_to_dict():
    reader = csv.DictReader(open("C:/Users/user/Desktop/Web_Study/Dance_Match/Dance_Total.csv"))
    result = {}
    for row in reader:
# Academy_Name 자리에는 csv 의 첫 열 이름이 들어간다
        key = row.pop('Academy_Name')
        result[key] = row

    return result

# Final insert statement
dbsparta.DanceMatch.insert_one(csv_to_dict())하세요