-
Notifications
You must be signed in to change notification settings - Fork 0
/
frequently_used.txt
44 lines (32 loc) · 1.09 KB
/
frequently_used.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
# jupyter dark theme https://github.com/dunovank/jupyter-themes
pip3 install jupyterthemes
jt -t chesterish -fs 95 -tfs 11 -nfs 115 -cellw 88% -T -N
# restore default theme
jt -r
# jupyter plot dark
from jupyterthemes import jtplot
jtplot.style(figsize = (20,8))
## pandas display settings
import pandas as pd
pd.options.display.max_colwidth = 100
pd.options.display.max_columns = 120
pd.options.display.max_rows = 1200
## postgres
import psycopg2
pg = "dbname='' user='' host='' password='' port=''"
conn = psycopg2.connect(pg)
cursor = conn.cursor()
cursor.execute(sql)
colnames = [desc[0] for desc in cursor.description]
rows = cursor.fetchall()
tmp = pd.DataFrame(rows, columns=colnames)
# conn.close()
# multiple plots on single image
fig, axs = plt.subplots(N, 2)
for i,ith in zip(df.columns[N:],range(N)):
for j,val in zip(range(2),['position','page']):
axs[ith, j].plot(df[[val,i]].groupby(val).mean(),)
axs[ith, j].set_title(i)
axs[ith, j].set_ylim(bottom=-0.1, top=1.1)
axs[ith, j].set_ylabel('percent of correct')
axs[ith, j].set_xlabel(val)