I have the following data:
import pandas as pd
data = {'mac':['84:3d:c6:4f:24:34', '00:a6:ca:86:5d:54', '00:f2:8b:31:ee:74', '00:27:e3:2e:b4:e4'],
'senal':[-49, -75, -50, -55],
'latitud': [40.332053, 40.332053, 40.332053, 40.332053],
'longitud': [-3.764498, -3.764498, -3.764498, -3.764498]}
df = pd.DataFrame(data)
And I would like to add a new columns by mac values and fill them with the corresponding value of signal. The output would be something like:
latitud, longitud, 84:3d:c6:4f:24:34, 00:a6:ca:86:5d:54, 00:f2:8b:31:ee:7, 00:27:e3:2e:b4:e4
40.332053, -3.764498, -49, -75, -50, -55