Nov-28-2019, 12:47 AM
I am very new to Python but I have a programming background.
I can read data from SQL query in EAV format (I am stuck with the data).
HOLEID, PROJECT, name, value
123, RH, a, b
123, RH, x, y
234, RH, a, c
I would like to pivot the data to a flat table and display it as
holeid, project, a, x
123, RH, b, y
234, RH, c, NULL
Is this possible in Python?
Thanks in advance
I can read data from SQL query in EAV format (I am stuck with the data).
HOLEID, PROJECT, name, value
123, RH, a, b
123, RH, x, y
234, RH, a, c
I would like to pivot the data to a flat table and display it as
holeid, project, a, x
123, RH, b, y
234, RH, c, NULL
Is this possible in Python?
Thanks in advance