query | a pythonic query language |
Sign in or create a new account. |
S(1@1) | R(n@1) |
---|---|
29.0 | 7 |
23.0 | 9 |
32.0 | 25 |
23.0 | 27 |
23.0 | 81 |
35.0 | 121 |
32.0 | 125 |
28.0 | 169 |
23.0 | 243 |
32.0 | 361 |
32.0 | 625 |
23.0 | 729 |
40.0 | 841 |
25.0 | 4 |
25.0 | 49 |
45.0 | 289 |
25.0 | 343 |
25.0 | 961 |
33.0 | 3 |
20.0 | 5 |
39.0 | 529 |
16.0 | 6 |
18.0 | 10 |
12.0 | 14 |
Parameters:
b, n, r
Both fields and conditions are made up of terms.
A term is a valid Python expression in a name space made up of:
database parameters;
any imported python modules;
PyQL Aggregators such as Average (A), Sum (S), and Replace (R);
and other domain specific terms.
About the Barely Rational Database | Sample Queries |
---|---|
n are integers from 2 to 1001.
r is the number of 'digits' required to represent 1/n (+1 for the bar). b is the base. Primes is a list of prime numbers. |
To see n vs r in base 10, use the PyQL: n,r@b=10
To see n vs r in base 10 graphically, use the PyQL:
To see n vs r for bases 2 - 10, use the PyQL:
To see n vs r for bases 2 - 10 for prime n, use the PyQL:
To see n vs r for bases 2 - 10 with icons colored by primeness, use the PyQL:
To see n v r/n for bases 2 - 10 with icons colored by primeness, use the PyQL:
To see n v r/n with icons colored by primeness for bases that are perfect squares, use the PyQL:
n v math.log(r/n) seems to have something to tell us:
What about those dots between the main lines in these graphics? Are there patterns to those barely rational numbers?
Let's have a peek with a histogram:
We can have a closer look with that most excellent data visualization tool called a table of numbers:
Another nice query is:
Let's continue to graphically explore the cases of non-integer n/r. To start, let's look at n/r between 1 and 2 with the PyQL:
There is a lot going on there and and coloring by oddness reveals a pattern:
Grouping by n being a perfect square shows in interesting set of numbers. |