Hello all,
I am trying to generate a variable that combines (list) of technology section that a assignee has.
For example, my data looks like:
And for the output, I would like to have something like:
I tried several things but I couldn't get what i wanted :/
Could someone please help me with this?
Thanks !!
I am trying to generate a variable that combines (list) of technology section that a assignee has.
For example, my data looks like:
Code:
* Example generated by -dataex-. For more info, type help dataex clear input str8 patent_id str246 unique_assignee str1 cpc_section float(patent_year m_ai_by_assignee rank_ai) "10957045" "Honk Kong Polytechnic University" "G" 2021 1 1 "11361359" "SPECRIGHT, INC." "G" 2022 1 2 "10877998" "Durga Turaga" "G" 2020 1 3 "11120568" "TOWER MAPPING AVIATION, LLC" "G" 2021 1 4 "11150720" "Sateesh Kumar Addepalli" "Y" 2021 1 5 "11150720" "Sateesh Kumar Addepalli" "G" 2021 1 5 "11225018" "Beijing Cloud Profound Technologies Company Limited" "B" 2022 1 6 "10921463" "Christopher Davis Williams" "B" 2021 1 7 "10921463" "Christopher Davis Williams" "G" 2021 1 7 "10737780" "VECTORED PROPULSION TECHNOLOGIES INC." "B" 2020 1 8 "10839792" "TOYOTA TECHNOLOGICAL INSTITUTE AT CHICAGO" "G" 2020 1 9 "11475667" "Monitoreal Limited" "H" 2022 1 10 "11475667" "Monitoreal Limited" "G" 2022 1 10 "11023733" "Flickstree Productions Pvt Ltd" "G" 2021 1 11 "11023733" "Flickstree Productions Pvt Ltd" "H" 2021 1 11 "11206462" "SCENER INC." "H" 2021 1 12 "10769864" "Auto-Measure Pty Limited" "G" 2020 1 13 "10905570" "POINT DESIGNS, LLC" "B" 2021 1 14 "10905570" "POINT DESIGNS, LLC" "A" 2021 1 14 "10733382" "DATAMARAN LIMITED" "G" 2020 1 15 "10607158" "C-SATS, Inc." "G" 2020 1 16 "10147052" "C-SATS, Inc." "G" 2018 1 16 "11455462" "Open Text Software SA ULC" "G" 2022 1 17 "9928649" "Amber Garage, Inc." "G" 2018 1 18 "9947230" "Amber Garage, Inc." "B" 2018 1 18 "9947230" "Amber Garage, Inc." "G" 2018 1 18 "11275841" "ADVERSA AI LTD" "G" 2022 1 19 "11501214" "SAVVI AI INC." "G" 2022 1 20 "11461204" "Skymizer Taiwan Inc." "G" 2022 1 21 "10709390" "LOGOS CARE, INC." "G" 2020 1 22 "10709390" "LOGOS CARE, INC." "A" 2020 1 22 "10984667" "JIVEWORLD, SPC" "G" 2021 1 23 "10984667" "JIVEWORLD, SPC" "H" 2021 1 23 "10898282" "Brent Andrew Bailey" "A" 2021 1 24 "10898282" "Brent Andrew Bailey" "B" 2021 1 24 "10898282" "Brent Andrew Bailey" "F" 2021 1 24 "11211185" "Airbornway Corporation" "B" 2021 1 25 "11211185" "Airbornway Corporation" "E" 2021 1 25 "10347401" "Airbornway Corporation" "H" 2019 1 25 "11211185" "Airbornway Corporation" "D" 2021 1 25 "10672542" "Airbornway Corporation" "H" 2020 1 25 "10672542" "Airbornway Corporation" "D" 2020 1 25 "10347401" "Airbornway Corporation" "D" 2019 1 25 "10347401" "Airbornway Corporation" "B" 2019 1 25 "11211185" "Airbornway Corporation" "H" 2021 1 25 "10672542" "Airbornway Corporation" "B" 2020 1 25 "11079216" "HANGZHOU DONGHUA CHAIN GROUP CO., LTD." "B" 2021 1 26 "11079216" "HANGZHOU DONGHUA CHAIN GROUP CO., LTD." "G" 2021 1 26 "11403355" "AI SOFTWARE, LLC" "G" 2022 1 27 "9792682" "RaPID Platforms LLC" "G" 2017 1 28 "9792682" "RaPID Platforms LLC" "A" 2017 1 28 "11521427" "SUQIAN UNIVERSITY" "G" 2022 1 29 "11392980" "SIMPLELIST CORPORATION" "G" 2022 1 30 "11393011" "SIMPLELIST CORPORATION" "G" 2022 1 30 "11170330" "SAFESITE SOLUTIONS, INC." "G" 2021 1 31 "11188836" "APPLYBOARD INC." "G" 2021 1 32 "11446575" "PlayerUnknown Productions B.V." "G" 2022 1 33 "11446575" "PlayerUnknown Productions B.V." "A" 2022 1 33 "11036940" "MMT SRL" "G" 2021 1 34 "11131992" "Sushrut Bhalla" "G" 2021 1 35 "10450091" "DroneTerminus LLC" "G" 2019 1 36 "10450091" "DroneTerminus LLC" "B" 2019 1 36 "10450091" "DroneTerminus LLC" "A" 2019 1 36 "10921809" "Autonomous Marine Systems, Inc." "G" 2021 1 37 "10921809" "Autonomous Marine Systems, Inc." "Y" 2021 1 37 "10921809" "Autonomous Marine Systems, Inc." "B" 2021 1 37 "11195327" "KATAM TECHNOLOGIES AB" "A" 2021 1 38 "11195327" "KATAM TECHNOLOGIES AB" "G" 2021 1 38 "9632509" "DRONOMY LTD." "G" 2017 1 39 "9632509" "DRONOMY LTD." "B" 2017 1 39 "9632509" "DRONOMY LTD." "H" 2017 1 39 "11004246" "2238534 ONTARIO INC." "G" 2021 1 40 "11087409" "Ocrolus, LLC" "G" 2021 1 41 "10864633" "SOUTHE AUTONOMY WORKS, LLC" "B" 2020 1 42 "10864633" "SOUTHE AUTONOMY WORKS, LLC" "G" 2020 1 42 "11423346" "Augmentir, Inc." "G" 2022 1 43 "10733483" "PROWLER.IO LIMITED" "G" 2020 1 44 "11106977" "Stratuscent Inc." "G" 2021 1 45 "10386379" "Stratuscent Inc." "B" 2019 1 45 "10386379" "Stratuscent Inc." "G" 2019 1 45 "10463980" "KYNEPROX S.R.L." "F" 2019 1 46 "10870062" "KYNEPROX S.R.L." "G" 2020 1 46 "10870062" "KYNEPROX S.R.L." "B" 2020 1 46 "10463980" "KYNEPROX S.R.L." "B" 2019 1 46 "10870062" "KYNEPROX S.R.L." "F" 2020 1 46 "10870062" "KYNEPROX S.R.L." "A" 2020 1 46 "10463980" "KYNEPROX S.R.L." "A" 2019 1 46 "10463980" "KYNEPROX S.R.L." "G" 2019 1 46 "10409875" "MARKETMUSE, INC." "G" 2019 1 47 "10489469" "MARKETMUSE, INC." "G" 2019 1 47 "11303845" "Alex Greaves" "G" 2022 1 48 "11303845" "Alex Greaves" "H" 2022 1 48 "11315162" "NUFRONTEER MEDIA INC." "G" 2022 1 49 "10962383" "UISEE (SHANGHAI) AUTOMOTIVE TECHNOLOGIES LTD." "G" 2021 1 50 "11411531" "PASCO Ventures LLC" "H" 2022 1 51 "11411531" "PASCO Ventures LLC" "F" 2022 1 51 "11411531" "PASCO Ventures LLC" "B" 2022 1 51 "9720519" "Pramod Kumar Verma" "G" 2017 1 52 "11104005" "NEUROMEKA" "G" 2021 1 53 "11104005" "NEUROMEKA" "B" 2021 1 53 end
And for the output, I would like to have something like:
| unique_assignee | cpc_section | total_section |
| XXX | A | A, B |
| XXX | B | A, B |
| YYY | C | C, D, E |
| YYY | D | C, D, E |
| YYY | E | C, D, E |
| UUU | F | F |
| QQQ | D | D |
I tried several things but I couldn't get what i wanted :/
Could someone please help me with this?
Thanks !!
Comment