chabanovsky’s gists

chabanovsky / 2022 year in closing

Created January 26, 2023 12:55

	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

chabanovsky / se_2021_in_closing.csv

Created January 3, 2022 09:56

We can make this file beautiful and searchable if this error is corrected: It looks like row 10 should actually have 15 columns, instead of 9 in line 9.

	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",

chabanovsky / se_2020_in_closing.csv

Last active September 14, 2021 20:06

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

chabanovsky / pandas_postgres.py

Created June 6, 2020 06:33 — forked from kunanit/pandas_postgres.py

Read postgres database table into pandas dataframe

	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',

chabanovsky / Настройки для шаблонных комментариев

Created February 6, 2017 09:35

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

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

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

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

chabanovsky / thousand_avatars.py

Created December 4, 2016 19:30

	# -- coding: utf-8 --

	import json, requests
	import os
	import sys
	import urllib

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

Nicolas chabanovsky