SHOW:
|
|
- or go back to the newest paste.
| 1 | - | SHA256 (pgmg6p.7z) = 04635f8f3034709f8b5d6dec64683cd853ad4c89654232dd64d3866b949038a3 |
| 1 | + | #THREAD https://boards.4channel.org/g/thread/69235901 |
| 2 | #SHA256 (pgmg6p.7z) = 04635f8f3034709f8b5d6dec64683cd853ad4c89654232dd64d3866b949038a3 | |
| 3 | #DB https://files.catbox.moe/pgmg6p.7z | |
| 4 | ||
| 5 | #WORD STATS | |
| 6 | #site popularity - https://pastebin.com/fDAAzUiS | |
| 7 | #fag https://pastebin.com/kNaP3phv | |
| 8 | #normie https://pastebin.com/8Fx1Wsa5 | |
| 9 | #incel https://pastebin.com/7feY2nWC | |
| 10 | ||
| 11 | ||
| 12 | #!/bin/bash | |
| 13 | for text in normie normalfag | |
| 14 | do | |
| 15 | for year in {2010..2018}
| |
| 16 | do | |
| 17 | for month in {1..12}
| |
| 18 | do | |
| 19 | month=$(printf '%02i' $month) | |
| 20 | # This can be optimized. | |
| 21 | sqlite3 \ | |
| 22 | "$1" \ | |
| 23 | "with month_posts as ( | |
| 24 | select | |
| 25 | timestamp, | |
| 26 | text | |
| 27 | from | |
| 28 | posts | |
| 29 | where | |
| 30 | strftime( | |
| 31 | '%Y%m', | |
| 32 | timestamp, | |
| 33 | 'unixepoch' | |
| 34 | ) == '$year$month' | |
| 35 | ) | |
| 36 | select | |
| 37 | '$text', | |
| 38 | '$year', | |
| 39 | '$month', | |
| 40 | ( | |
| 41 | select | |
| 42 | count(text) | |
| 43 | from | |
| 44 | month_posts | |
| 45 | ) | |
| 46 | as total, | |
| 47 | ( | |
| 48 | select | |
| 49 | count(text) | |
| 50 | from | |
| 51 | month_posts | |
| 52 | where | |
| 53 | text like '%$text%' | |
| 54 | ) | |
| 55 | as count | |
| 56 | where | |
| 57 | total > 0" | |
| 58 | done | |
| 59 | done | |
| 60 | done | |
| 61 | ||
| 62 | #!/bin/bash | |
| 63 | # https://github.com/dinedal/textql | |
| 64 | textql \ | |
| 65 | -header \ | |
| 66 | -sql "select | |
| 67 | normalfag.year, | |
| 68 | normalfag.month, | |
| 69 | normalfag.total, | |
| 70 | normalfag.count as normalfag_count, | |
| 71 | normie.count as normie_count | |
| 72 | from | |
| 73 | ( | |
| 74 | select | |
| 75 | year, | |
| 76 | month, | |
| 77 | total, | |
| 78 | count | |
| 79 | from | |
| 80 | data | |
| 81 | where | |
| 82 | text = 'normalfag' | |
| 83 | ) | |
| 84 | as normalfag | |
| 85 | join | |
| 86 | ( | |
| 87 | select | |
| 88 | year, | |
| 89 | month, | |
| 90 | total, | |
| 91 | count | |
| 92 | from | |
| 93 | data | |
| 94 | where | |
| 95 | text = 'normie' | |
| 96 | ) | |
| 97 | as normie | |
| 98 | on | |
| 99 | normalfag.year = normie.year | |
| 100 | and | |
| 101 | normalfag.month = normie.month | |
| 102 | and | |
| 103 | normie.count > normalfag.count" \ | |
| 104 | "$1" | |
| 105 | ||
| 106 | ||
| 107 | #!/usr/bin/gnuplot --persist | |
| 108 | set title '"Normalfag" vs "normie"' | |
| 109 | set ylabel 'Count' | |
| 110 | set xlabel 'Date' | |
| 111 | set grid | |
| 112 | ||
| 113 | set datafile separator "," | |
| 114 | set xdata time | |
| 115 | set timefmt '%Y,%m' | |
| 116 | set format x "%Y-%m" | |
| 117 | ||
| 118 | plot \ | |
| 119 | "< grep normalfag data.txt" using 2:5 title "normalfag" with lines, \ | |
| 120 | "< grep normie data.txt" using 2:5 title "normie" with lines |
