I have a workflow that extract AirBnb data from URLs and find out if certain features are offered in a listing. For example I am looking to see if a listing offers WiFi (Case Insensitive) or Dedicated Workspace or Long Term Stay Allowed. Final data appears as below, counting them as 1 or 0 based if these features are offered for a listing.
I got first few things working, and I am stuck where how I could parse specific features and put 1 and 0 against them in the output. I have attached workflow I am using.
ID | URL | WiFi | Long Term Stay | Dedicated workspace |
16910794 | https://www.airbnb.com/rooms/16910794 | 1 | 0 | 0 |
12654250 | https://www.airbnb.com/rooms/12654250 | 1 | 0 | 1 |
Thank you for the help
@Raj Thanks, what I was hoping to get is how can we extract the features I am interested in from the Regex. If you see 2nd Regex it randomly pick 3 columns in the output. I was trying to get a method to look for the features we care about as an output from there.
User | Count |
---|---|
17 | |
15 | |
15 | |
8 | |
5 |