Nicolas chabanovsky

## 2022 year in closing
Site Name,Asked,AskedAndClosed,PctAskedAndClosed,AllClosed,DuplicatesClosed,DuplicatesReopened,OTClosed,OTReopened,UnclearClosed,UnclearReopened,TooBroadClosed,TooBroadReopened,OpinionBasedClosed,OpinionBasedReopened
Stack Overflow,2360129,387977,16.44,408890,133521,3685,120892,1484,89456,1172,51340,551,13681,125
Super User,32556,5074,15.59,5223,720,31,2757,52,1327,44,135,5,284,5
Server Fault,17393,1729,9.94,1792,172,0,1286,4,245,2,43,0,46,0
Stack Apps,225,46,20.44,52,13,0,32,0,7,0,0,0,0,0
Seasoned Advice,1122,232,20.68,243,97,3,70,4,29,5,2,0,45,3
Home Improvement,8307,1310,15.77,1530,128,4,509,12,549,20,154,15,190,6
Game Development,3141,404,12.86,503,85,3,250,12,94,3,40,2,34,0
Arqade,3148,688,21.86,1038,428,9,310,3,221,6,17,1,62,4
Geographic Information Systems,16462,3836,23.3,4319,435,36,1907,144,1025,94,771,127,181,7

## se_2021_in_closing.csv
Asked,AskedAndClosed,PctAskedAndClosed,AllClosed,DuplicatesClosed,DuplicatesReopened,OTClosed,OTReopened,UnclearClosed,UnclearReopened,TooBroadClosed,TooBroadReopened,OpinionBasedClosed,OpinionBasedReopened,Site Name
"2637207","438198","16.62","454987","142760","4165","127895","1859","106048","2097","61079","842","17205","222","Stack Overflow"
"40841","6459","15.81","6601","1044","50","3538","47","1523","68","162","7","334","8","Super User"
"20918","3055","14.6","3154","236","2","2375","7","433","1","59","2","51","0","Server Fault"
"202","27","13.37","41","6","","32","","3","","0","","0","","Stack Apps"
"1538","382","24.84","399","174","8","102","6","32","4","16","3","75","2","Cooking"
"9228","743","8.05","931","114","5","352","11","300","6","63","0","102","1","Home Improvement"
"4390","662","15.08","773","117","7","444","21","106","7","59","3","47","0","Game Developers"
"5022","1095","21.8","1228","443","6","409","16","277","9","28","5","71","2","Gaming"
"17264","3511","20.34","3816","523","25","1685","159",

## se_2020_in_closing.csv

          
            Site
            Asked
            AskedAndClosed
            PctAskedAndClosed
            AllClosed
            DuplicatesClosed
            DuplicatesReopened
            OTClosed
            OTReopened
            UnclearClosed
            UnclearReopened
            TooBroadClosed
            TooBroadReopened
            OpinionBasedClosed
            OpinionBasedReopened

            
              Stack Overflow
              3077287
              504944
              16.41
              521241
              151348
              4872.0
              144942
              3192.0
              118557
              3579.0
              86831
              1746.0
              19563
              277.0

            
              Super User
              51316
              9415
              18.35
              9660
              1189
              36.0
              5065
              82.0
              2239
              93.0
              677
              16.0
              490
              4.0

            
              Server Fault
              26301
              4064
              15.45
              4322
              285
              6.0
              2982
              15.0
              769
              6.0
              209
              1.0
              77
              2.0

            
              Stack Apps
              204
              26
              12.75
              26
              1
              0.0
              23
              0.0
              1
              0.0
              0
              0.0
              1
              0.0

            
              Cooking
              2340
              510
              21.79
              527
              210
              4.0
              145
              5.0
              69
              5.0
              31
              2.0
              72
              4.0

            
              Home Improvement
              10754
              857
              7.97
              1016
              106
              4.0
              457
              5.0
              310
              6.0
              79
              2.0
              64
              1.0

            
              Game Developers
              5326
              797
              14.96
              876
              150
              7.0
              461
              21.0
              80
              3.0
              106
              3.0
              79
              5.0

            
              Gaming
              6795
              1848
              27.2
              2109
              765
              13.0
              604
              13.0
              601
              19.0
              72
              6.0
              67
              4.0

            
              GIS
              19727
              3788
              19.2
              4090
              591
              28.0
              1602
              89.0
              1052
              90.0
              616
              96.0
              229
              9.0

## pandas_postgres.py
import pandas as pd
from sqlalchemy import create_engine

# follows django database settings format, replace with your own settings
DATABASES = {
    'production':{
        'NAME': 'dbname',
        'USER': 'user',
        'PASSWORD': 'pass',
        'HOST': 'rdsname.clqksfdibzsj.us-east-1.rds.amazonaws.com',

## Настройки для шаблонных комментариев
###[Q] Исчерпывающий ответ
Если вам дан исчерпывающий ответ, отметьте его как верный (галка напротив выбранного ответа).

###[Q] Вопрос опросник
Вопросы опросники запрещены в сообществе. Для повторного открытия, перефразируйте ваш вопрос так, чтобы на него можно было дать однозначно правильный ответ.

###[Q] Короткий вопрос
Постарайтесь писать более развернутые вопросы. Поясните, в чем именно вы видите проблему, как её воспроизвести, что вы хотите получить в результате и т. д.

###[Q] Похоже на спам

## thousand_avatars.py
# -*- coding: utf-8 -*-

import json, requests
import os
import sys
import urllib

reload(sys)
sys.setdefaultencoding('utf-8')
	Site Name,Asked,AskedAndClosed,PctAskedAndClosed,AllClosed,DuplicatesClosed,DuplicatesReopened,OTClosed,OTReopened,UnclearClosed,UnclearReopened,TooBroadClosed,TooBroadReopened,OpinionBasedClosed,OpinionBasedReopened
	Stack Overflow,2360129,387977,16.44,408890,133521,3685,120892,1484,89456,1172,51340,551,13681,125
	Super User,32556,5074,15.59,5223,720,31,2757,52,1327,44,135,5,284,5
	Server Fault,17393,1729,9.94,1792,172,0,1286,4,245,2,43,0,46,0
	Stack Apps,225,46,20.44,52,13,0,32,0,7,0,0,0,0,0
	Seasoned Advice,1122,232,20.68,243,97,3,70,4,29,5,2,0,45,3
	Home Improvement,8307,1310,15.77,1530,128,4,509,12,549,20,154,15,190,6
	Game Development,3141,404,12.86,503,85,3,250,12,94,3,40,2,34,0
	Arqade,3148,688,21.86,1038,428,9,310,3,221,6,17,1,62,4
	Geographic Information Systems,16462,3836,23.3,4319,435,36,1907,144,1025,94,771,127,181,7
	Asked,AskedAndClosed,PctAskedAndClosed,AllClosed,DuplicatesClosed,DuplicatesReopened,OTClosed,OTReopened,UnclearClosed,UnclearReopened,TooBroadClosed,TooBroadReopened,OpinionBasedClosed,OpinionBasedReopened,Site Name
	"2637207","438198","16.62","454987","142760","4165","127895","1859","106048","2097","61079","842","17205","222","Stack Overflow"
	"40841","6459","15.81","6601","1044","50","3538","47","1523","68","162","7","334","8","Super User"
	"20918","3055","14.6","3154","236","2","2375","7","433","1","59","2","51","0","Server Fault"
	"202","27","13.37","41","6","","32","","3","","0","","0","","Stack Apps"
	"1538","382","24.84","399","174","8","102","6","32","4","16","3","75","2","Cooking"
	"9228","743","8.05","931","114","5","352","11","300","6","63","0","102","1","Home Improvement"
	"4390","662","15.08","773","117","7","444","21","106","7","59","3","47","0","Game Developers"
	"5022","1095","21.8","1228","443","6","409","16","277","9","28","5","71","2","Gaming"
	"17264","3511","20.34","3816","523","25","1685","159",
Site	Asked	AskedAndClosed	PctAskedAndClosed	AllClosed	DuplicatesClosed	DuplicatesReopened	OTClosed	OTReopened	UnclearClosed	UnclearReopened	TooBroadClosed	TooBroadReopened	OpinionBasedClosed	OpinionBasedReopened
Stack Overflow	3077287	504944	16.41	521241	151348	4872.0	144942	3192.0	118557	3579.0	86831	1746.0	19563	277.0
Super User	51316	9415	18.35	9660	1189	36.0	5065	82.0	2239	93.0	677	16.0	490	4.0
Server Fault	26301	4064	15.45	4322	285	6.0	2982	15.0	769	6.0	209	1.0	77	2.0
Stack Apps	204	26	12.75	26	1	0.0	23	0.0	1	0.0	0	0.0	1	0.0
Cooking	2340	510	21.79	527	210	4.0	145	5.0	69	5.0	31	2.0	72	4.0
Home Improvement	10754	857	7.97	1016	106	4.0	457	5.0	310	6.0	79	2.0	64	1.0
Game Developers	5326	797	14.96	876	150	7.0	461	21.0	80	3.0	106	3.0	79	5.0
Gaming	6795	1848	27.2	2109	765	13.0	604	13.0	601	19.0	72	6.0	67	4.0
GIS	19727	3788	19.2	4090	591	28.0	1602	89.0	1052	90.0	616	96.0	229	9.0
	import pandas as pd
	from sqlalchemy import create_engine

	# follows django database settings format, replace with your own settings
	DATABASES = {
	'production':{
	'NAME': 'dbname',
	'USER': 'user',
	'PASSWORD': 'pass',
	'HOST': 'rdsname.clqksfdibzsj.us-east-1.rds.amazonaws.com',
	###[Q] Исчерпывающий ответ
	Если вам дан исчерпывающий ответ, отметьте его как верный (галка напротив выбранного ответа).

	###[Q] Вопрос опросник
	Вопросы опросники запрещены в сообществе. Для повторного открытия, перефразируйте ваш вопрос так, чтобы на него можно было дать однозначно правильный ответ.

	###[Q] Короткий вопрос
	Постарайтесь писать более развернутые вопросы. Поясните, в чем именно вы видите проблему, как её воспроизвести, что вы хотите получить в результате и т. д.

	###[Q] Похоже на спам
	# -- coding: utf-8 --

	import json, requests
	import os
	import sys
	import urllib

	reload(sys)
	sys.setdefaultencoding('utf-8')