Displaying multiple inventors, applicants, IPC codes in same row (next to each other) rather than below each other
Posted: Wed Jan 12, 2022 3:13 pm
Dear community,
I want to extract patents that pertain to a series of IPC codes across different application authority and I am interested in having the information about the nationality of the applicant(s) and inventor(s).
I would like to export the data in the format 1 patent application (i.e. unique application_id) = 1 row in the dataset.
At the moment, I receive multiple rows for patents that have more than one inventor, applicant or IPC class. Is it possible to have these additional inventors in an extra column in the same row (i.e. "next to each other rather than below each other")? This would make the dataprocessing easier.
For example I have a patent that has multiple inventors from Austria, Germany and Japan which creates 8 rows for the same patent application, but I would like to have 1 row with columns Applicant1, Applicant2, IPC1, IPC2 etc. I can also add the query as soon as I have but I am waiting for my collaborator to send it to me.
Regards
Fabian
I want to extract patents that pertain to a series of IPC codes across different application authority and I am interested in having the information about the nationality of the applicant(s) and inventor(s).
I would like to export the data in the format 1 patent application (i.e. unique application_id) = 1 row in the dataset.
At the moment, I receive multiple rows for patents that have more than one inventor, applicant or IPC class. Is it possible to have these additional inventors in an extra column in the same row (i.e. "next to each other rather than below each other")? This would make the dataprocessing easier.
For example I have a patent that has multiple inventors from Austria, Germany and Japan which creates 8 rows for the same patent application, but I would like to have 1 row with columns Applicant1, Applicant2, IPC1, IPC2 etc. I can also add the query as soon as I have but I am waiting for my collaborator to send it to me.
Regards
Fabian