def count_word(content_business): count_word = WordCloud().process_text(content_business) word, frequently = count_word.keys(), count_word.values() count_word = pd.DataFrame([word, frequently]).T count_word.columns = ['word', 'frequently'] count_word = count_word.sort_values(by='frequently', ascending=False) return count_word
def read_data(): data = pd.read_csv('../data_csv/misubishi.csv') data_table = data.dropna() print(data_table['Content'].head()) content_business = ','.join(data_table['Content']) count_word = WordCloud().process_text(content_business) word, frequently = count_word.keys(), count_word.values() count_word = pd.DataFrame([word, frequently]).T count_word.columns = ['word', 'frequently'] count_word = count_word.sort_values(by='frequently', ascending=False) print(count_word)