I have some code which works, data is read in from a text file as a list of dicts, the code takes the keys and values from each dict in for loops. While it works I am sure there is a better way to do it than mine below:
Code
JavaScript
x
35
35
1
data_list = [{'Clk': '190', '50%': '5.3149999999999995', '100%': '4.715'},
2
{'Clk': '195', '50%': '5.295', '100%': '4.765'},
3
{'Clk': '200', '50%': '5.395', '100%': '4.9'},
4
{'Clk': '205', '50%': '5.55', '100%': '4.970000000000001'},
5
{'Clk': '210', '50%': '5.68', '100%': '5.005'},
6
{'Clk': '215', '50%': '5.725', '100%': '5.08'},
7
{'Clk': '220', '50%': '5.85', '100%': '5.215'},
8
{'Clk': '225', '50%': '6.03', '100%': '5.35'},
9
{'Clk': '230', '50%': '6.140000000000001', '100%': '5.395'},
10
{'Clk': '235', '50%': '6.074999999999999', '100%': '5.37'},
11
{'Clk': '240', '50%': '6.02', '100%': '5.345'},
12
{'Clk': '245', '50%': '6.025', '100%': '5.49'},
13
{'Clk': '290', '50%': '5.67', '100%': '5.37'}]
14
15
#print(data_list)
16
#print('n'*3)
17
Clk = []
18
av_50 = []
19
av_100 = []
20
for dicty in data_list:
21
for k,v in dicty.items():
22
#print(" ", v)
23
if k == "Clk":
24
Clk.append(dicty["Clk"])
25
if k == "50%":
26
av_50.append(dicty["50%"])
27
if k == "100%":
28
av_100.append(dicty["100%"])
29
print('n'*3)
30
print(Clk)
31
print('n')
32
print(av_50)
33
print('n')
34
print(av_100)
35
Outputs
JavaScript
1
8
1
['190', '195', '200', '205', '210', '215', '220', '225', '230', '235', '240', '245', '290']
2
3
4
['5.3149999999999995', '5.295', '5.395', '5.55', '5.68', '5.725', '5.85', '6.03', '6.140000000000001', '6.074999999999999', '6.02', '6.025', '5.67']
5
6
7
['4.715', '4.765', '4.9', '4.970000000000001', '5.005', '5.08', '5.215', '5.35', '5.395', '5.37', '5.345', '5.49', '5.37']
8
Advertisement
Answer
I would recommand using pandas.DataFrame
very convenient way to
JavaScript
1
22
22
1
import pandas as pd
2
3
data_list = [{'Clk': '190', '50%': '5.3149999999999995', '100%': '4.715'},
4
{'Clk': '195', '50%': '5.295', '100%': '4.765'},
5
{'Clk': '200', '50%': '5.395', '100%': '4.9'},
6
{'Clk': '205', '50%': '5.55', '100%': '4.970000000000001'},
7
{'Clk': '210', '50%': '5.68', '100%': '5.005'},
8
{'Clk': '215', '50%': '5.725', '100%': '5.08'},
9
{'Clk': '220', '50%': '5.85', '100%': '5.215'},
10
{'Clk': '225', '50%': '6.03', '100%': '5.35'},
11
{'Clk': '230', '50%': '6.140000000000001', '100%': '5.395'},
12
{'Clk': '235', '50%': '6.074999999999999', '100%': '5.37'},
13
{'Clk': '240', '50%': '6.02', '100%': '5.345'},
14
{'Clk': '245', '50%': '6.025', '100%': '5.49'},
15
{'Clk': '290', '50%': '5.67', '100%': '5.37'}]
16
17
my_data=pd.DataFrame(data_list)
18
19
20
clk = my_data['Clk'].tolist()
21
clk
22
Regards