0

I am struggling with dealing with a csv file that scraped one crowdfunding website.

My goal is loading the csv file on Stata, and save it in .dta format. (Stata dataset).

Stata successfully loaded the dataset, like the screenshot I attached. v20, v21 are variables I wanted.

In v22, I wanted to know the name of "creator". However, it is not successfully excluded. As the selected cell in the screenshot shows. enter image description here Is there any way that I can extract "name" and "id" of the creator as separate columns?

Also, in v23, I want to extract the location of each row. enter image description here However, I found the "name", "state", "short_name" are in the cell, without being extracted separately. enter image description here

Would there be any way that I can load them as separate columns?

Thank you for reading my post! Any help will be appreciated:)

David Specht
  • 7,784
  • 1
  • 22
  • 30
Juno Oh
  • 23
  • 3
  • Also, I tried to load data using R (readr package). However, the result was the same. – Juno Oh Jun 09 '22 at 18:27
  • 1
    please share the file, some rows. Do not share only some images. – aborruso Jun 10 '22 at 05:55
  • @aborruso Thank you so much for your comments. I posted with the actual three rows: https://stackoverflow.com/questions/72594048/how-can-i-extract-some-contents-in-the-cells-of-web-scraped-csv-file – Juno Oh Jun 12 '22 at 16:35

0 Answers0