How do you analyze data for patterns?

Question

MySQL

There is a database with data on the radiation background with the fields id, time, radiation. There are periodic background jumps in the data. How can you try to identify the dependence of jumps on the time of day, on the day of the week, etc.? It can be seen by eye that there are mostly jumps during the day in the middle of the week, but I want more accurate data. Like getting a graph of the density of the distribution of jumps in time or something ..

Answer 1

build a function using any of their mashinelearning methods,
although for natural phenomena and statistical

Answer 2

Y-axis: Up - background jumps
X-axis: Right - time

Answer 3

To build any graphs, there is a divine gnuplot, how to select data from mysql so that it would be convenient to process it depends on how exactly the data is stored (i.e. it is not possible to prompt the query itself), but something like SELECT WEEKDAY (time), HOUR ( time), radiation FROM table WHERE time>date_start AND time

Answer 4

Add spectra, both classical Fourier and wavelets (time-frequency).