Alternatives for storing and analyzing data

For this example I placed (stored) exactly the data that you put in a file and I went through it and remove the data, this file being tests.txt is in the same folder as the file with the code, store) in ficheiro.csv :

dados = {}
with open('tests.txt', 'r') as f:
    for line in f:
        params = [i.strip() for i in line.split('  ') if i.strip() != '']
        if not params:
            continue
        data, hora, v1, l1, v2, l2 = params
        dados[data] = dados.get(data, {})
        dados[data][hora] = dados[data].get(hora, [])
        dados[data][hora].append((v1, l1, v2, l2))

In this line [i.strip() for i in line.split(' ') if i.strip() != ''] . Note that if you can, it would be much simpler to separate the data per line by only ex: ";" which would be: [i.strip() for i in line.split(';')] instead of fickle spaces like puseste, and without empty lines could also be checked, if not params: continue .

However this code is fully functional for the data / format you put

You can access every day and / or time like this:

Day:

print(dados['15/dez'])

Output:

  

{'06:05': ('1.01', '0.33', '0.28', '0.00'), ('0.10', '0.32', '0.29', '0.33' '' 0.35 ',' 0.30 ',' 0.00 '), (' 0.061 ',' 0.311 ',' 0.251 ',' 0.312 ')], '06: 04': [ '' .17 '', '' 0.051 '), ('15 .82', '0.25', '15 .82 ',' 0.181 '), ('12 .41', '0.30', '13 .00 ',' '0.22', '8.72', '0.161'), ('2.84', '0.31', '3.11', '0.281'), ('2.38', '0.25', '2.60', ' (1.69, 0.36, 1.79, 0.301), ('1.07', '0.27', '1.16', '0.241' '), (' 1.02 ',' 0.21 ',' 1.10 ',' 0.171 ')]}

Time (here you go to the various measures of each hour):

print(dados['15/dez']['06:05'])

Output:

  ('0.10', '0.32', '0.29', '0.33'), ('1.09', '0.35', ' 0.30 ',' 0.00 '), (' 0.061 ',' 0.311 ',' 0.251 ',' 0.312 ')]

Here I will leave an alternative using defaultdict :

from collections import [defaultdict][1]

dados = defaultdict(dict)
with open('tests.txt', 'r') as f:
    for line in f:
        params = [i.strip() for i in line.split('  ') if i.strip() != '']
        if not params:
            continue
        data, hora, v1, l1, v2, l2 = params
        if hora not in dados[data]:
            dados[data][hora] = []
        dados[data][hora].append((v1, l1, v2, l2))
print(dados)

It does, but I find it unnecessary to use a database, since you do not seem to have much experience with it.

Search for CSV, you can save your data in a saved .txt within the same project, when you need it again just reopen csv. There are several libraries in python to assist you in managing CSV files, it is the easiest way to store small data.

If you want a database you can use Firebase, it works by the cloud and it's very simple to use. For local banks I recommend SQLite.