broadway | Lightweight App extensibility and hookable middleware

I have a large data set which I show below:

I have a data set representing the NYC Citibike trips. The data looks like this:

I have a dataset with two columns on_road and at_road, the combination of which make up a string called geocode_string. With this string, I wish to geocode these intersections using my google API key. As an example, I have on_road = Silverdale and at_road = W 28th St, which combine to form geocode_string = Silverdale and W 28th St, Cleveland, OH.

However, when I try and use the geocode function from ggmap, I get this message: "SILVERDALE and W ..." not uniquely geocoded, using "silverdale ave, cleveland, oh 44109, usa".

It seems in this case that R just assumes a location by default, in this case just silverdale ave. I would like to have R not do this- perhaps just to leave blank the locations for which a unique geocode cannot be found. I can then go through and manually find the coordinates for such cases. I just would like to flag the observations in some way.

I'd also like to point out that in the second row of the dataset, I get S MARGINAL RD and W 93RD ST , CLEVELAND , OH, an intersection that does not exist in Cleveland. When I paste that string into google maps, it seems to search for a partial match and gives me the coordinates for S Marginal Rd. Any thoughts why an intersection that does not exist would generate coordinates in this case, but not the Silverdale case described above? Is there any way to prevent this from happening?

I would greatly appreciate any help!

My question might have asked earlier but the scenario im working for im not getting any help.

Been tried different methods and things but still no luck, any help would be appreciated

Question

Im trying to load a text file from URL https://www.sec.gov/Archives/edgar/cik-lookup-data.txt, so I can modify the data and create a dataframe.

Example:- data from the link

1188 BROADWAY LLC:0001372374:

119 BOISE, LLC:0001633290:

11900 EAST ARTESIA BOULEVARD, LLC:0001639215:

11900 HARLAN ROAD LLC:0001398414:

11:11 CAPITAL CORP.:0001463262:

I should get below output

I'm practicing web-scraping and trying to grab the reviews from the following page: https://www.yelp.com/biz/jajaja-plantas-mexicana-new-york-2?osq=Vegetarian+Food

This is what I have so far after inspecting the name element on the webpage:

My code looks something like this at the moment:

I am just getting started with regular expressions (working with the stringr package), and I have written some code that does not do exactly what I want it to do. I am working with a dataset with some very messy string data and am trying to clean it up to be used with a google maps API.

I've attached a sample of the data below.

Basically, I want to select every row where loc_01 is a simple street name. By this, I mean I want it to take on the following formats:

A numbered street, such as 10th Ave; A named street, such as MAIN ST, and any directional modification of such street names (such as 10TH AVE NW, W MAIN ST, or W 10TH AVE.)

I have tried the following expression:

I'm experimenting with CSS in a codecademy project, and I noticed that when I set a footer to have fixed positioning (with no left/right/top/bottom properties set), it just disappears. I would expect it to just shrink the way it does with absolute positioning, but it doesn't. Without fixed positioning the footer is there where it should be, but with it, it's gone. Why is it behaving this way?

The footer in question is selected in the CSS in the footer ruleset.

Here's the codepen: https://codepen.io/megas4ever/pen/ExwEEzv

And here's the full code:

Below is my ContactTopForm component.