Thread: Prime Gap News
View Single Post
Old 2020-12-02, 09:48   #205
SethTro
 
SethTro's Avatar
 
"Seth"
Apr 2019

24·17 Posts
Default Lines on merit graph

Most of my work is on a single K=P#/d (see how these form lines on this graph)

I was curious which primorial had the most records so I wrote this ugly command.

Code:
$ sqlite3 gaps.db 'SELECT startprime FROM gaps' | sed -n 's!^[^/]*[^0-9/]\([0-9]\+#\).*!\1!p' | sort | uniq -c | sort -nr | awk '$1 > 200 { ("sqlite3 gaps.db \"SELECT discoverer, count(*) FROM gaps WHERE startprime like \\\"%" $2 "%\\\" GROUP BY 1 ORDER BY 2 DESC LIMIT 1\"") | getline freq; print($0 "\t" freq); }'
   1361 4441#    S.Troisi|1310
    962 9439#    Jacobsen|868
    925 6761#    Jacobsen|913
    786 49999#   Rosnthal|786
    739 4139#    Jacobsen|717
    617 2221#    S.Troisi|537
    579 9973#    Rosnthal|525
    535 10343#   Jacobsen|528
    400 6199#    DStevens|370
    376 6661#    S.Troisi|322
    372 5003#    Jacobsen|344
    351 9629#    RobSmith|269
    350 10709#   RobSmith|334
    276 4409#    Rosnthal|229
    262 23197#   RobSmith|258
    240 5333#    S.Troisi|219
    228 18481#   PierCami|226
    223 20963#   RobSmith|221
    217 8887#    S.Troisi|199
    216 3331#    Jacobsen|186
    211 23189#   RobSmith|209
    206 5557#    S.Troisi|174
SethTro is offline   Reply With Quote