You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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:
Open up the AboutThisFile.txt to read more about this file
Open Google Sheets in Chrome
Click on File>Import and located the PLS_FY17.csv file
Leave all of the default options and select "Import Data" (not sure if this is correct, see attached image)
Look in the ADDRESS column and notice that the values contain the
latitude and longitude in parenthesis after the library address.
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
Which part of the content does your suggestion apply to?
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:
Survey
file.
AboutThisFile.txt
to read more about this filePLS_FY17.csv file
ADDRESS
column and notice that the values contain thelatitude and longitude in parenthesis after the library address.
longitude into a new column named 'latlong'. HINT: Look up the
function
REGEXEXTRACT
in Google Sheets. That function expects thefirst argument to be a string (a cell in
ADDRESS
column) and aquoted 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](https://private-user-images.githubusercontent.com/6465940/313472679-006bd949-1711-494c-b9e6-7e378e12d7ce.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjYxMTQ1MzksIm5iZiI6MTcyNjExNDIzOSwicGF0aCI6Ii82NDY1OTQwLzMxMzQ3MjY3OS0wMDZiZDk0OS0xNzExLTQ5NGMtYjllNi03ZTM3OGUxMmQ3Y2UucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI0MDkxMiUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNDA5MTJUMDQxMDM5WiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9N2FkYmExYjQwNmYwOWI0YTI1MjBlNTNiZjdlYTc0ZTE1ODgxNjAxMTllMWM3NWE0ZDIxOWY5NWFmMjA5MmRkZSZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QmYWN0b3JfaWQ9MCZrZXlfaWQ9MCZyZXBvX2lkPTAifQ.0ltNFnaGkGqesritVMlg77MA6WTY_Jw8Og5ULznJ8tA)
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
The text was updated successfully, but these errors were encountered: