search

LibraryCarpentry / lc-data-intro

Library Carpentry: Introduction to Working with Data (Regular Expressions)
https://librarycarpentry.org/lc-data-intro/
Other
29 stars 84 forks source link

Extracting a substring in Google Sheets using regex #221

Open doujouDC opened 5 months ago

doujouDC commented 5 months ago

How could the content be improved?

Hey,

Another comment about this lesson. In this section it is not clear (at least to me) how to import the data into Google Sheets. I really dont use this tool, so I would suggest something like this:

  1. Export and unzip the 2017 Public Library Survey file.
  2. Open up the AboutThisFile.txt to read more about this file
  3. Open Google Sheets in Chrome
  4. Click on File>Import and located the PLS_FY17.csv file
  5. Leave all of the default options and select "Import Data" (not sure if this is correct, see attached image)
  6. Look in the ADDRESS column and notice that the values contain the latitude and longitude in parenthesis after the library address.
  7. Construct a regular expression to match and extract the latitude and longitude into a new column named 'latlong'. HINT: Look up the function REGEXEXTRACT in Google Sheets. That function expects the first argument to be a string (a cell in ADDRESS column) and a quoted regular expression in the second.

Also, I am attaching a screenshot that I got when importing the survey data into Google Sheets. Do I leave all of the default options selected (please see attached image)

Thanks

Doug

google-sheets-import

Which part of the content does your suggestion apply to?

https://github.com/LibraryCarpentry/lc-data-intro/blob/main/episodes/02-match-extract-strings.md