I'm trying to scrape information from a few doctor profiles and export a field with multiple records into one row.
One of the fields (a list of insurances) has multiple records and when I export to CSV those fields end up on multiple rows, instead of just one row.
How do I fix this? Ideally, there would be one row for each doctor and the list of insurances would be organized into one cell in the same row in the form of an array, e.g., "Aetna, Agewell, Blue Cross Blue Shield"
Thanks for the help
Url: https://nyulangone.org/doctors/treatment/primary-care?searchRadius=&page=1
Sitemap:
{"_id":"doctor-list-forum-question","startUrl":["https://nyulangone.org/doctors/treatment/primary-care?searchRadius=&page=1"],"selectors":[{"id":"doctor-link","type":"SelectorLink","parentSelectors":["_root"],"selector":"a.provider-tile__provider-name","multiple":true,"delay":0},{"id":"insurance-list","type":"SelectorText","parentSelectors":["doctor-link"],"selector":"a[toggle-target^='#plans']","multiple":true,"regex":"","delay":0}]}