# -*- coding: utf-8 -*-
"""
Created on Sat Nov 16 14:03:26 2019


# 使用的为2018年的

list1=[此处为获取的excel中文表头];
       
def getIndexByValue(value,list):
    all_index=[i for i, a in enumerate(list) if a == value];
    if(len(all_index) > 0):
        return all_index[0];
    else:
        return -1;
# 生成的字典对照
dictJY = {"lys20191020":"微信机器人"};


# 把list转化成json
def changeListToJson(list):
    str="{";
    for i,v in enumerate(list):
        if((i+1)==len(list)):
            str+="\"\":\""+v+"\"";
        else:
            str+="\"\":\""+v+"\",";
        
    str+="}";
    return str

def changeDictionaryToHiveSql(dictJY):
    str="CREATE TABLE ODS_JYSJXX (";
    for k,v in dictJY.items():
            str+=k+" STRING COMMENT '"+v+"',\n";
    str+=")";
    return str


def ReNameHeaderToCSV(fileName,csvName,dictionary):
    rmapping = {}
    for k, v in dictJY.items():
        rmapping[v] = k
    import pandas as pd
    xl = pd.read_excel(fileName)
    xl = xl.rename(columns=rmapping)
    xl.to_csv(csvName)

def changeDictionaryToSchema(dictJY):
    str="";
    for k,v in dictJY.items():
            str+="{\"name\": \""+k+"\",\"type\": [\"string\",\"null\"]},";
    return str

print(changeDictionaryToSchema(dictJY))

#ReNameHeaderToCSV('excel/2018.xlsx','2018.csv',dictJY)
#ReNameHeaderToCSV('excel/2017.xlsx','2017.csv',dictJY)