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
data_list = [{'Clk': '190', '50%': '5.3149999999999995', '100%': '4.715'}, {'Clk': '195', '50%': '5.295', '100%': '4.765'}, {'Clk': '200', '50%': '5.395', '100%': '4.9'}, {'Clk': '205', '50%': '5.55', '100%': '4.970000000000001'}, {'Clk': '210', '50%': '5.68', '100%': '5.005'}, {'Clk': '215', '50%': '5.725', '100%': '5.08'}, {'Clk': '220', '50%': '5.85', '100%': '5.215'}, {'Clk': '225', '50%': '6.03', '100%': '5.35'}, {'Clk': '230', '50%': '6.140000000000001', '100%': '5.395'}, {'Clk': '235', '50%': '6.074999999999999', '100%': '5.37'}, {'Clk': '240', '50%': '6.02', '100%': '5.345'}, {'Clk': '245', '50%': '6.025', '100%': '5.49'}, {'Clk': '290', '50%': '5.67', '100%': '5.37'}] #print(data_list) #print('n'*3) Clk = [] av_50 = [] av_100 = [] for dicty in data_list: for k,v in dicty.items(): #print(" ", v) if k == "Clk": Clk.append(dicty["Clk"]) if k == "50%": av_50.append(dicty["50%"]) if k == "100%": av_100.append(dicty["100%"]) print('n'*3) print(Clk) print('n') print(av_50) print('n') print(av_100)
Outputs
['190', '195', '200', '205', '210', '215', '220', '225', '230', '235', '240', '245', '290'] ['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'] ['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']
Advertisement
Answer
I would recommand using pandas.DataFrame
very convenient way to
import pandas as pd data_list = [{'Clk': '190', '50%': '5.3149999999999995', '100%': '4.715'}, {'Clk': '195', '50%': '5.295', '100%': '4.765'}, {'Clk': '200', '50%': '5.395', '100%': '4.9'}, {'Clk': '205', '50%': '5.55', '100%': '4.970000000000001'}, {'Clk': '210', '50%': '5.68', '100%': '5.005'}, {'Clk': '215', '50%': '5.725', '100%': '5.08'}, {'Clk': '220', '50%': '5.85', '100%': '5.215'}, {'Clk': '225', '50%': '6.03', '100%': '5.35'}, {'Clk': '230', '50%': '6.140000000000001', '100%': '5.395'}, {'Clk': '235', '50%': '6.074999999999999', '100%': '5.37'}, {'Clk': '240', '50%': '6.02', '100%': '5.345'}, {'Clk': '245', '50%': '6.025', '100%': '5.49'}, {'Clk': '290', '50%': '5.67', '100%': '5.37'}] my_data=pd.DataFrame(data_list) clk = my_data['Clk'].tolist() clk
Regards