Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import pandas as pd
- import pymysql
- import numpy as np
- db = pymysql.connect(host='localhost', user='root', passwd='',
- database='mom_db', charset='utf8')
- df = pd.read_sql("SELECT * FROM comments ", db)
- cursor = db.cursor()
- name = df['nickname']
- count = pd.value_counts(name)
- a = {count.index[i]:count[i] for i in range(len(count))}
- print(a)
- #print(count[count>1])-вывод Series
- {'repeinik': 26, 'podberezowik': 24, 'Павел_Шуков_talks48': 20, 'stupich':
- 14, 'kipovets': 14, 'Лайош_Портиш': 13, 'vijigau_mraz': 13, 'наивная баба':
- 12, 'genek77': 12, 'Sergey_Petrov': 12, 'Андрей_Иванов_talks19': 11,
- 'Пачотны тунеядзец': 10, 'eugenenus_': 10, 'Настя_Романова': 9, 'Kac_Lol':
- 9, 'Ириша_Лалапусечка': 9, 'valstar78': 8, 'Сергей Александрович': 8,
- 'Tadeush_Тадеуш': 8, 'freedom for us': 7, 'Светлана_Малышкина': 7,
- 'Костя_Миронов': 7, 'SIgarA': 6, 'Жанна_Д-урк': 6, 'Fair play': 6,
- 'Лукашенко_Федор': 6, 'Lisa_Grodno': 5, 'id350886439': 5,......
- repeinik 26
- podberezowik 24
- Павел_Шуков_talks48 20
- stupich 14
- kipovets 14
- Лайош_Портиш 13
- .......
Add Comment
Please, Sign In to add comment