Productivity

pinyin.py

import pandas as pd
import jieba, itertools

def to_pinyin(sentence):
    segments = jieba.cut(sentence)
    output = " ".join(segments)
    pinyined = pinyin(output)
    combined = list(itertools.chain.from_iterable(pinyined))
    return ''.join(combined)
# Import
words = pd.read_excel('vocabulary.xlsx', encoding='GBK')
# Add pinyin
words['Pinyin'] = words['Mandarin'].apply(to_pinyin)
# Export
words.to_excel('vocabulary_pinyin.xlsx')