我得到了如下所示一组数据集,
如何在Python中提取出每个系列的X,Y,Z的值?
我实际上稍后需要计算每个数列的标准差。 (x,y,z标准偏差)
{'deviceTimestamp': 166230, 'x': 3.5538, 'y': -9.7006, 'z': 3.3077}, {'deviceTimestamp': 166250, 'x': -1.4629, 'y': -7.0692, 'z': 2.2308}, {'deviceTimestamp': 166260, 'x': -6.7571, 'y': -5.0299, 'z': -0.076923}, {'deviceTimestamp': 166280, 'x': -5.0319, 'y': -6.5896, 'z': -0.076923}, {'deviceTimestamp': 166300, 'x': -0.21122, 'y': -8.9002, 'z': 2.5}, {'deviceTimestamp': 166320, 'x': 6.3477, 'y': -9.3142, 'z': 4.5385}, {'deviceTimestamp': 166340, 'x': 10.904, 'y': -9.9498, 'z': 5.6538}, {'deviceTimestamp': 166360, 'x': 9.5501, 'y': -8.5014, 'z': 5.6923}, {'deviceTimestamp': 166380, 'x': 7.7312, 'y': -8.5973, 'z': 5.6154}, {'deviceTimestamp': 166400, 'x': 8.9783, 'y': -10.132, 'z': 4.7692}, {'deviceTimestamp': 166420, 'x': 9.8307, 'y': -11.159, 'z': 5.0385}, {'deviceTimestamp': 166440, 'x': 7.7934, 'y': -10.556, 'z': 5.8077}, {'deviceTimestamp': 166460, 'x': 5.8261, 'y': -10.259, 'z': 2.8462}, {'deviceTimestamp': 166480, 'x': 4.4837, 'y': -10.092, 'z': 1.6538}, {'deviceTimestamp': 166500, 'x': 5.5556, 'y': -11.08, 'z': 1.8462}, {'deviceTimestamp': 166520, 'x': 8.4009, 'y': -12.06, 'z': 1.0}
你可以使用列表理解来构造一个包含x,y,z的列表。
data = [
{'deviceTimestamp': 166230, 'x': 3.5538, 'y': -9.7006, 'z': 3.3077},
{'deviceTimestamp': 166250, 'x': -1.4629, 'y': -7.0692, 'z': 2.2308},
{'deviceTimestamp': 166260, 'x': -6.7571, 'y': -5.0299, 'z': -0.076923},
{'deviceTimestamp': 166280, 'x': -5.0319, 'y': -6.5896, 'z': -0.076923},
{'deviceTimestamp': 166300, 'x': -0.21122, 'y': -8.9002, 'z': 2.5},
{'deviceTimestamp': 166320, 'x': 6.3477, 'y': -9.3142, 'z': 4.5385},
{'deviceTimestamp': 166340, 'x': 10.904, 'y': -9.9498, 'z': 5.6538},
{'deviceTimestamp': 166360, 'x': 9.5501, 'y': -8.5014, 'z': 5.6923},
{'deviceTimestamp': 166380, 'x': 7.7312, 'y': -8.5973, 'z': 5.6154},
{'deviceTimestamp': 166400, 'x': 8.9783, 'y': -10.132, 'z': 4.7692},
{'deviceTimestamp': 166420, 'x': 9.8307, 'y': -11.159, 'z': 5.0385},
{'deviceTimestamp': 166440, 'x': 7.7934, 'y': -10.556, 'z': 5.8077},
{'deviceTimestamp': 166460, 'x': 5.8261, 'y': -10.259, 'z': 2.8462},
{'deviceTimestamp': 166480, 'x': 4.4837, 'y': -10.092, 'z': 1.6538},
{'deviceTimestamp': 166500, 'x': 5.5556, 'y': -11.08, 'z': 1.8462},
{'deviceTimestamp': 166520, 'x': 8.4009, 'y': -12.06, 'z': 1.0}
]
coordinates = [[d['x'], d['y'], d['z']] for d in data]
则坐标
列表为:
[[3.5538, -9.7006, 3.3077],
[-1.4629, -7.0692, 2.2308],
[-6.7571, -5.0299, -0.076923],
[-5.0319, -6.5896, -0.076923],
[-0.21122, -8.9002, 2.5],
[6.3477, -9.3142, 4.5385],
[10.904, -9.9498, 5.6538],
[9.5501, -8.5014, 5.6923],
[7.7312, -8.5973, 5.6154],
[8.9783, -10.132, 4.7692],
[9.8307, -11.159, 5.0385],
[7.7934, -10.556, 5.8077],
[5.8261, -10.259, 2.8462],
[4.4837, -10.092, 1.6538],
[5.5556, -11.08, 1.8462],
[8.4009, -12.06, 1.0]]
假设您使用的是Python3
data = {'deviceTimestamp': 166230, 'x': 3.5538, 'y': -9.7006, 'z': 3.3077}, {'deviceTimestamp': 166250, 'x': -1.4629, 'y': -7.0692, 'z': 2.2308}, {'deviceTimestamp': 166260, 'x': -6.7571, 'y': -5.0299, 'z': -0.076923}, {'deviceTimestamp': 166280, 'x': -5.0319, 'y': -6.5896, 'z': -0.076923}, {'deviceTimestamp': 166300, 'x': -0.21122, 'y': -8.9002, 'z': 2.5}, {'deviceTimestamp': 166320, 'x': 6.3477, 'y': -9.3142, 'z': 4.5385}, {'deviceTimestamp': 166340, 'x': 10.904, 'y': -9.9498, 'z': 5.6538}, {'deviceTimestamp': 166360, 'x': 9.5501, 'y': -8.5014, 'z': 5.6923}, {'deviceTimestamp': 166380, 'x': 7.7312, 'y': -8.5973, 'z': 5.6154}, {'deviceTimestamp': 166400, 'x': 8.9783, 'y': -10.132, 'z': 4.7692}, {'deviceTimestamp': 166420, 'x': 9.8307, 'y': -11.159, 'z': 5.0385}, {'deviceTimestamp': 166440, 'x': 7.7934, 'y': -10.556, 'z': 5.8077}, {'deviceTimestamp': 166460, 'x': 5.8261, 'y': -10.259, 'z': 2.8462}, {'deviceTimestamp': 166480, 'x': 4.4837, 'y': -10.092, 'z': 1.6538}, {'deviceTimestamp': 166500, 'x': 5.5556, 'y': -11.08, 'z': 1.8462}, {'deviceTimestamp': 166520, 'x': 8.4009, 'y': -12.06, 'z': 1.0}
for item in data:
print(item[x])
print(item[y])
print(item[z])
list_ = [{'deviceTimestamp': 166230, 'x': 3.5538, 'y': -9.7006, 'z': 3.3077}, {'deviceTimestamp': 166250, 'x': -1.4629, 'y': -7.0692, 'z': 2.2308}, {'deviceTimestamp': 166260, 'x': -6.7571, 'y': -5.0299, 'z': -0.076923}, {'deviceTimestamp': 166280, 'x': -5.0319, 'y': -6.5896, 'z': -0.076923}, {'deviceTimestamp': 166300, 'x': -0.21122, 'y': -8.9002, 'z': 2.5}, {'deviceTimestamp': 166320, 'x': 6.3477, 'y': -9.3142, 'z': 4.5385}, {'deviceTimestamp': 166340, 'x': 10.904, 'y': -9.9498, 'z': 5.6538}, {'deviceTimestamp': 166360, 'x': 9.5501, 'y': -8.5014, 'z': 5.6923}, {'deviceTimestamp': 166380, 'x': 7.7312, 'y': -8.5973, 'z': 5.6154}, {'deviceTimestamp': 166400, 'x': 8.9783, 'y': -10.132, 'z': 4.7692}, {'deviceTimestamp': 166420, 'x': 9.8307, 'y': -11.159, 'z': 5.0385}, {'deviceTimestamp': 166440, 'x': 7.7934, 'y': -10.556, 'z': 5.8077}, {'deviceTimestamp': 166460, 'x': 5.8261, 'y': -10.259, 'z': 2.8462}, {'deviceTimestamp': 166480, 'x': 4.4837, 'y': -10.092, 'z': 1.6538}, {'deviceTimestamp': 166500, 'x': 5.5556, 'y': -11.08, 'z': 1.8462}, {'deviceTimestamp': 166520, 'x': 8.4009, 'y': -12.06, 'z': 1.0}]
x = []
y = []
z = []
for dict_ in list_:
x.append(dict_['x'])
y.append(dict_['y'])
z.append(dict_['z'])
print('x:', x)
print('y:', y)
print('z:', z)
输出:
x: [3.5538, -1.4629, -6.7571, -5.0319, -0.21122, 6.3477, 10.904, 9.5501, 7.7312, 8.9783, 9.8307, 7.7934, 5.8261, 4.4837, 5.5556, 8.4009]
y: [-9.7006, -7.0692, -5.0299, -6.5896, -8.9002, -9.3142, -9.9498, -8.5014, -8.5973, -10.132, -11.159, -10.556, -10.259, -10.092, -11.08, -12.06]
z: [3.3077, 2.2308, -0.076923, -0.076923, 2.5, 4.5385, 5.6538, 5.6923, 5.6154, 4.7692, 5.0385, 5.8077, 2.8462, 1.6538, 1.8462, 1.0]