original_list = ['a', 'b', 'b', 'a', 'd', 'd', 'b', 'z', 'c', 'b', 'r', 's', 'h', 'f', 'f', 's', 'b', 'b', 'y', 'b']

counter = {}

for i in original_list:

    if original_list.count(i) > 1:

        counter[i] = original_list.count(i)

# 按字典的值，进行从大到排序

counter_list = list(zip(counter.values(), counter.keys()))

counter1_list = sorted(counter_list, reverse=True)

# # 按字典的键，进行从大到排序

# counter1 = sorted(counter.items(), key=lambda x: x[0], reverse=True)

for counter1 in counter1_list:

    print(counter1)

import xlrd

excel_path = r'********'

data = xlrd.open_workbook(excel_path).sheet_by_name("sheet1")

n_rows = data.nrows  # 行数

for i in range(0, n_rows):

    # 每一行数据

    row_values = data.row_values(i)

    print(row_values)

import pandas as pd

dict_content_list = [{'a': '', 'b': ''}, {'a': '', 'b': ''}]

data = pd.DataFrame(dict_content_list)

data.to_excel('./***.xls', encoding='utf8', index=False)

a_list = ['', '', '', '', '', '', '', '']

counter = {}

for i in a_list:

    if a_list.count(i) > 0:

        counter[i] = a.count(i)

# 按字典的值，进行从大到排序

counter_list = list(zip(counter.values(), counter.keys()))

counter1_list = sorted(counter_list, reverse=True)

# # 按字典的键，进行从大到排序

# counter1 = sorted(counter.items(), key=lambda x: x[0], reverse=True)

for counter1 in counter1_list:

    print(counter1)

import csv

test_list = ['a', 'b', 'c']

with open(f'test.csv', "a+", encoding='utf-8', newline='') as f:

    writer = csv.writer(f, dialect="excel")

    writer.writerow(test_list)

import pymongo

import xlrd

client = pymongo.MongoClient(host='192.168.0.193', port=27017)

db_storage = client.liuxue['liuxue']

excel_path = r'C:\Users\Administrator\Desktop\留学.xlsx'

data = xlrd.open_workbook(excel_path).sheets()[0]

# 读取excel第一行数据作为存入mongodb的字段名

rows_tag = data.row_values(0)

n_rows = data.nrows

for i in range(1, n_rows):

    # 将字段名和excel数据存储为字典形式

    result_dict = dict(zip(rows_tag, data.row_values(i)))

    print(result_dict)

    db_storage.insert_one(result_dict)

counter = {}

# 按字典的值，进行从大到排序

counter_list = list(zip(counter.values(), counter.keys()))

counter1_list = sorted(counter_list, reverse=True)

# 按字典的键，进行从大到排序

counter1 = sorted(counter.items(), key=lambda x: x[0], reverse=True)