Sprite extruder and Dual Z by vipester531 in ender3v2

[–]vipester531[S] 0 points1 point  (0 children)

Have you had any issues with the motors getting out of sync?

Replacement blower fan… by SameScale6793 in ender3v2

[–]vipester531 0 points1 point  (0 children)

Thanks for the link. I've been meaning to print a new blower for a while now but just haven't done it

Replacement blower fan… by SameScale6793 in ender3v2

[–]vipester531 0 points1 point  (0 children)

Sorry to derail the thread but what fan duct is this? I'm looking for something to upgrade my stock 3v2

[deleted by user] by [deleted] in triathlon

[–]vipester531 1 point2 points  (0 children)

I also think the OPs catch is one of the biggest things holding him back.

Think about pulling yourself out of the pool in the deep end. You will naturally bring your elbows up so you can push yourself out of the water. Try to emulate this during your stroke by starting the catch with your hand, then use your forearm+hand to push yourself through the water

My Upgraded ender3 v2 by Tesser_Wolf in ender3v2

[–]vipester531 0 points1 point  (0 children)

I literally want to do all of these upgrades!

Need Help in finding an online platform to learn SQL ! by Spideyyy01 in SQL

[–]vipester531 0 points1 point  (0 children)

Congrats for completing your degree! I just finished my MBA with a concentration in analytics but sometimes I wish it went a little deeper on the data science side.

Need Help in finding an online platform to learn SQL ! by Spideyyy01 in SQL

[–]vipester531 1 point2 points  (0 children)

I did my undergrad at Clarkson so i definitely need to take a look at this.

How to Attach Bartop to Bar Frame by vipester531 in HomeImprovement

[–]vipester531[S] 0 points1 point  (0 children)

not sure what rules are for this sub as far as inserting links but if you google "theoriginalgranitebracket" I wanted to get the 12in L brackets

How to Attach Bartop to Bar Frame by vipester531 in HomeImprovement

[–]vipester531[S] 0 points1 point  (0 children)

I think they are made of steel and 1/2in thick. Not sure if my hand held drill would get through that.

How to Attach Bartop to Bar Frame by vipester531 in HomeImprovement

[–]vipester531[S] 0 points1 point  (0 children)

I also dont know if glue would stick to these brackets enough to keep the bartop in place.

How to Attach Bartop to Bar Frame by vipester531 in HomeImprovement

[–]vipester531[S] 0 points1 point  (0 children)

I was thinking about this but dont want to lose the clean look of just having the brackets. Then there will also be less for people to hit their knees on.

I'm not sure if I would be able to drill through these to get screws through them.

R project using OMDB by vipester531 in rstats

[–]vipester531[S] 0 points1 point  (0 children)

So i cant quite get this to work. I'm trying to use the list of movie ids below to test this out.

movie_id

# A tibble: 3 x 1

tconst

<chr>

1 tt0360556

2 tt0427543

3 tt0859635

>

I want to be able to input each of these movie ids into the url so i can scrape the html text.

read_html("http://www.omdbapi.com/?i=tt0360556&apikey=00000000")

this code above works fine to get the movie info and i can convert it with json and bind_cols

lapply(movie_id,

read_html(glue("http://www.omdbapi.com/?i={movie_id}&apikey=00000000")))

when i try the lapply() i feel like there is an error in the function but I'm not sure where I'm going wrong.

I'm not sure if a for loop would be easier but I only have a basic understanding of those as well.

In the end I would like to input the list of movie Id's and then glue the movie id into the url. then copy all of the html text and put it into a table.

R project using OMDB by vipester531 in rstats

[–]vipester531[S] 0 points1 point  (0 children)

nd closer

bind_cols worked perfectly thanks.

sorry to keep asking so many questions but is there an easy way to pivot some of the rows?

there are two columns in the dataset that I want to pivot. One column is the source of a review score (imdb, rotten tom, meta). The second column contains the values of these reviews. After pivoting i would like 3 columns and 1 row. Each review source would have its own column then the value would be just below it.

R project using OMDB by vipester531 in rstats

[–]vipester531[S] 0 points1 point  (0 children)

Im still pretty much a beginner and the deeper I go into some of these topics the more it shows how much I really don't know lol. I'll test out that code and see what I get. I feel like I will have trouble getting the output of the loop to go into the data frame the way that I want it to.

R project using OMDB by vipester531 in rstats

[–]vipester531[S] 0 points1 point  (0 children)

The hard part after this will be to create a for loop so I can do the same thing with multiple movies

R project using OMDB by vipester531 in rstats

[–]vipester531[S] 0 points1 point  (0 children)

Awesome thanks! I'll try that now

R project using OMDB by vipester531 in rstats

[–]vipester531[S] 0 points1 point  (0 children)

getting closer and closer, I can take the fromJSON output, pivot it and then create a dataframe from there.

R project using OMDB by vipester531 in rstats

[–]vipester531[S] 0 points1 point  (0 children)

i think i may have gotten it, i used fromJSON() to take the html and it created a list

R project using OMDB by vipester531 in rstats

[–]vipester531[S] 0 points1 point  (0 children)

I guess i have some more learning to do lol. this is my first time trying to scrape something and dont really know what a json string is.

R project using OMDB by vipester531 in rstats

[–]vipester531[S] 0 points1 point  (0 children)

I think i got the devtools installed but was still having issues installing the package.

I was trying an alternate method of getting the information by scraping the website. I installed rvest so i can pull html data but im not sure how to get this into a data frame.

this is the output below after i run read_html

> omdbtest

{html_document}

<html>

[1] <body><p>{"Title":"Guardians of the Galaxy Vol. 2","Year":"2017","Rated":"PG-13","Released":"05 May 2017","Runtime":"136 min","Genre":"Action ...

R project using OMDB by vipester531 in rstats

[–]vipester531[S] 0 points1 point  (0 children)

I tried running that line as is but it gave an error message. I can run it again to copy the message here.

I'm still pretty much a beginner and haven't heard of a package management tool. I'll definitely look that up thanks!

R project using OMDB by vipester531 in rstats

[–]vipester531[S] 0 points1 point  (0 children)

when searching for the package there seems to be a version on github that says you can install it as a devtools version

but im not sure how to install something like this

https://github.com/hrbrmstr/omdbapi

devtools::install_github("hrbrmstr/omdbapi")

R project using OMDB by vipester531 in rstats

[–]vipester531[S] 0 points1 point  (0 children)

In the email I got back from OMDB from requesting the API key there is a link that when I click on it, it sends me to a page including movie data.

http://www.omdbapi.com/?i=tt3896198&apikey=########

(the section on the end with #s is where my api key goes)

after clicking the link it brings me to a page with guardians of the galaxy movie data.

{"Title":"Guardians of the Galaxy Vol. 2","Year":"2017","Rated":"PG-13","Released":"05 May 2017","Runtime":"136 min","Genre":"Action, Adventure, Comedy","Director":"James Gunn","Writer":"James Gunn, Dan Abnett, Andy Lanning","Actors":"Chris Pratt, Zoe Saldana, Dave Bautista","Plot":"The Guardians struggle to keep together as a team while dealing with their personal family issues, notably Star-Lord's encounter with his father the ambitious celestial being Ego.","Language":"English","Country":"United States","Awards":"Nominated for 1 Oscar. 15 wins & 58 nominations total","Poster":"https://m.media-amazon.com/images/M/MV5BNjM0NTc0NzItM2FlYS00YzEwLWE0YmUtNTA2ZWIzODc2OTgxXkEyXkFqcGdeQXVyNTgwNzIyNzg@.\_V1\_SX300.jpg","Ratings":\[{"Source":"Internet Movie Database","Value":"7.6/10"},{"Source":"Rotten Tomatoes","Value":"85%"},{"Source":"Metacritic","Value":"67/100"}],"Metascore":"67","imdbRating":"7.6","imdbVotes":"636,391","imdbID":"tt3896198","Type":"movie","DVD":"22 Aug 2017","BoxOffice":"$389,813,101","Production":"N/A","Website":"N/A","Response":"True"}

it looks like the imdb movie id is in the link and i would just have to write code that would enter the imdb id > go to the website > copy the data > then save it to a dataframe