Happy New Year. We all had quite the 2021, didn't we? I'm really hoping that this year is better. One thing that is happening this year is the Nintendo Switch is turning five years old. Mm-hmm, half a decade. I honestly can't believe it's been that long. That means we have all been enjoying Nintendo Switch games for the last half a decade. And I've been creating videos about the Switch for the last half a decade. It's been really interesting to watch myself, but also all these other creators bloom and explode using Nintendo Switch as their backbone. I mean, some more than others, but I made it my own. And I'm very proud of how we've grown on this channel, the way my content is now, what we've done with the Switch over the last five years. We've done some crazy things. And I'm just so thankful for all of those moments and all of those memories. And as corny as it is, all of the friends that I've made along the way, both you guys, but also other content creators. And that's what brought me to this video, because I'm not the only content creator that covers Nintendo on Nintendo Switch content. What if I did one big mega collab where I get the top Nintendo YouTubers to talk about their favorite Nintendo Switch game? Every single person said yes. I couldn't be more excited to work with everyone. All right, the first creator I'm going to start with. Someone who became a really close friend to me this year specifically. But we've got the chance to hang out now a couple of times and it's very clear that we gel together very well. And that is my buddy, my clone bubble. What? You didn't have to say all those nice things about me. You didn't have to go so thick on the paint. You didn't have to go so hard on the gas with all those nice things you said about me and how great I am at Mario Maker. Mario Maker is the most played game on my Switch. Next to Smash Bros. Ultimate. But I figured other people were talking about Smash Bros. So I'm talking about Mario Maker. Also, I don't know what happened, but now people think of me as the Mario Maker guy. People come up to me at conventions and stuff and have me sign their copy of Mario Maker, which is weird. I didn't work on the game, but it's also kind of awesome. Anyway, I love Mario Maker because the original Super Mario Bros. is my favorite game of all time. I've played that game over and over and over and over again. And Super Mario Maker is just more of that community made levels. And they're not all great levels, but they're curated pretty well. And it's pretty easy to figure out which ones are going to be really good. But I totally get it. Mario Maker 2 is a really hard sell. I feel like Nintendo really screwed up the marketing here because they made it seem like it's mostly for people who make levels. I've only ever made one level in Mario Maker 2. I made like three or four in the original Mario Maker. Yeah, it's great for people who make levels, but if you don't like making levels, you are just getting a Mario game with an endless supply of levels. How is that not awesome to you? Also, it's a hard sell because if you watch streamers or content creators play Mario Maker 2, it might look really, really hard. But that's just because they're playing expert or super expert levels. You have difficulty sliders. You can choose the difficulty of the levels that you want given to you.  And if you couldn't guess, Nintendo knows how to make levels. The multiplayer is also awesome in theory. It only works about 50% of the time, but that 50% that it works, it's awesome. The other 50%, oh, it's like a slideshow. The Nintendo Switch online just ain't it. It's definitely one of, if not my favorite game for the Nintendo Switch. I understand it's not exactly for everybody. It's just a Mario game with weird levels Nintendo never would have put in a Mario game. It feels like a ROM hack, but it's official. If you were ever on the fence about getting it because you thought, well, I'm never going to make that many levels, you should get it. If you like Mario games, you will love this one. Anyway, thanks for having me wood on your little year in review video. There's a lot of people in this video. Did anybody tell you look great today? I can't see you at all. I feel like by this point, everyone should know who Bobby is. We've done enough videos together. Next is a overwhelmingly wholesome creator who a lot of you know, and I've gotten to know over the last year or so. And that's the wonderful, wonderful Austin John was going on. I'm so happy to be a part of this video with you guys other than the bozo Bob Wolf who's a complete Benny. Now, I mean, look, my favorite Nintendo Switch game of all time has to be Pokemon Sword and Shield because it's more fun than going to the local Wawa to pick up some disco fries and a pork roll. Okay, would I'm not going to read it. I'm not going to read the thing you wrote when it comes to your selection of Pokemon games for the Nintendo Switch. You have a lot of options. You have Pokemon Let's Go Pikachu and Eevee, which is a fantastic beginner part of the series. You have Pokemon Quest, which is free to start. You have the brand new released Pokemon Brilliant Diamond Shining Pearl, which is a remake of fourth generation games. Very true to the original, but between Pokemon Sword and Shield and the DLC, it's actually my favorite Pokemon game of all time. Beating out Pokemon Heart, Gold and Soul Silver. I know it's a little weird to say, but honestly, it is the Pokemon selection is fantastic. The story feels appropriate for Pokemon and the region of Galar is based off of the UK and it's pretty fun to explore. Max Raid Battles are a fun and at times challenging part of these games that lets you team up with friends or random changers on the Internet. Always be careful with random changers on the Internet to take down some very powerful Pokemon. The DLC brings you to a tropical region and a frozen tundra, each with its own individual quest lines, new areas to explore, new Pokemon only available in those areas and new and fun ways to encounter legendary Pokemon. In addition, they made competitive much more approachable with the removal of some moves and reworking Pokemon available in these games. It's easier to catch competitively viable Pokemon, train them up and optimize them. Plus, Pokemon Broly Diamond, Shining Pearl and Pokemon Legends Arceus each have a different play style and a limited Pokemon selection than Pokemon Sword and Shield. So Sword and Shield is going to remain the competitive game for the time being. Until Pokemon Legends Arceus comes out in less than a month, this is definitely my favorite Pokemon game and if you had to pick up one for the Nintendo Switch, I definitely recommend Pokemon Sword or Shield with the DLC. Back to you Wolf, or Bob, or whoever's up on the thing. Great. Happy New Year. Any chance I can have to mess with Bob, even when I'm writing a script for another creator to create Fake Beef? I'm down for it. Speaking of beautiful creators, the next one, mmm, so handsome. So Dashing, so Charming. I'm telling you, if I wasn't taken, let's cut to them now. I would, yeah, it's me. Also, fun fact, I burped while testing my mic, and it sounded really gross. Testing one, two, test it, one, two. Yeah, all right, kind of weird that I'm in my own video, I guess not that weird. There was just a couple games that didn't make it into the video, and even though this video is supposed to be these creators and their favorite games, not a top 10 Switch games or anything like that, it still didn't feel right not to include them, so I'm gonna really quickly do it myself. Metroid Dread released fairly recently and became an instant classic in the Nintendo Switch Library. It's a sequel to Metroid Fusion that was two decades in the making, and while it only released fairly recently, it already won 2021's Game of the Year award. Obviously, a Metroidvania type game. I guess you really could just say a Metroid type game. I mean, these 2D Metroids are so genre-defying that they literally defined an entire genre. And I said this recently in my review of the game that you can go and watch. It's on this very channel. But it's so cool that the Metroid series created this genre of games, and still in 2021 manages to release a new game in that genre, and be as good if not better than all of the incredible games it has inspired over the last 20, 30 years. But yeah, there's obviously so much more I can say and have said in my review, so I'll leave it there. Thanks, me. If you don't know, when I stand here, my computer is right there. I do both in the same room. The next creator, I am jealous of every time they upload a video, because their camera quality, audio quality, and overall video quality and presentation takes a giant steamy dump on anything I ever managed to put together. Oh, I think I did this exact same cameo for Bob like two years ago, talking about the same game. Whatever, it works. It's fine. The Switch has had an absolutely incredible library, but when I think about first part of games especially, games that you can't play anywhere else that I love on the system, I got to talk about Fire Emblem Three Houses. I have been a long time fan of the Fire Emblem series. I've been playing them since Blazing Blade first came over to the West on the GBA. I haven't missed a release since then, though I haven't necessarily finished all of them right when they came out. But the point is, long time fan. And something I've always really enjoyed about the series is each new game tries to do something a little different from the ones before, whether that's adding a new mechanic, a little bit of different spin on how the story is done, and Three Houses did this in a really big way. In fact, it's probably the most different Fire Emblem game in terms of mechanics. It keeps some of the kind of traditional formulas, plot points, gameplay stuff intact, but then throws all of it into this school setting, which I gotta be honest, when I first heard about it, I wasn't entirely sure how I would feel about it, but then actually getting my hands on and playing it, I loved every second of it. Learning a little bit from some of the stuff that did in Fire Emblem Fates, the game gave you three different houses you could join, each which had their own little storyline, some of which definitely did have some overlapping plot that was very similar, if not the same, but ultimately they still go in very different directions with pretty different endings that I really appreciated, and each one kind of gave you little bits of the puzzle. You couldn't really just play one storyline and leave it at that. There was a lot of reasons to go back and play others because each one gave you just little bits more information about different things to give you the whole picture of the game's setting and plot, which was a really nice touch. Cast Overall was fantastic, like with any game with a cast of the size, there were definitely characters that I liked a lot more than others, but I feel like there was a good balance of them across each and every house, and the fact that you could recruit pretty much all of them, except for a couple of, you know, major characters, gave the ability to still have some of your favorites no matter which storyline you're doing. You know, and I gotta be honest, I really enjoyed this kind of remix on the core formula so much that I actually kind of hope they don't do it again. Sometimes, you know, when a new mechanic or concept does really well, they decide to just do it all over again and start to like dig in more, but I really like the idea of this being its own specific unique existence and stand apart from all the other games in the franchise. And it's not just the storytelling and characters that really pulled the whole thing off. I mean, that was definitely one of the big highlights for me, but the core gameplay was also excellent, good level of difficulty, and especially on the higher challenge levels. The map designs, the re-deviced character system where instead of each character having specific classes they're tied to, you're able to kind of freely experiment a little more. There were definitely some classes that each one excelled at more so than others. It was really just a well-developed package that I think did an excellent job of being something that maintained the kind of core pillars of what makes Fire Room special, but putting its own little twist on it that makes it stand apart. I'm gonna sound like a little bit of a broken record today, but everyone in this video are genuinely my friends.  Kevin, I met him at a convention in California a couple of years back, and he's just the sweetest man you'll meet. But going from the sweetest man you'll meet to the absolute swallest, buffest, sexiest man you'll meet, a man of which I am in a group chat, a fitness group chat with, helping me hit my weight gain goals. This dude is jacked, spawned away. So we're about five years into the Switch's life, and there are a lot of incredible experiences on the system, but if I had to recommend one game that I think everyone should at least play, that's Dragon Quest XI-S. Now, this game came out originally, just Dragon Quest XI on the PC and PS4 back in 2017. Years later in 2020, this Dragon Quest XI-S version released bringing a whole slew of new features. Now, the game itself came out at a time when we're hearing more and more traditional turn-based JRPG franchises make the push towards a more action-oriented setup with its gameplay, but Dragon Quest XI came out and is as traditional a turn-based JRPG as it gets. The characters, they're diverse, with pretty expansive backstories, and the new S version continues to build on that with more storylines kind of overarching that, along with the big massive story, not necessarily breaking ground, but it's enough to keep you invested in playing through what ends up being at least a 50-hour experience just through the main storyline. You then start to talk about end-game content, which there's quite a few, even after the credits roll and all the extra side quests. You can get lost in this game for easily 100 hours plus. The character designs come from the very talented Akira Toriyama, and when it's blended with Unreal Engine 4, gives the entire game this unique but familiar look. It's kind of hard to describe. When you start playing through it, you'll understand what I mean. They also worked in this really cool thing where you can switch between 2D and 3D. The 2D is obviously a call back to the 16-bit era with the Super Nintendo and a whole massive library of RPGs there. But if you're someone who's been looking for a really good polished turn-based RPG, this is it. This is the one to pick up. And I think it works perfectly with the Switch's hybrid concept because it does lean into the idea of pick up and play sessions where maybe you want to grind out certain rare materials in the game or just play through a couple of battles in order to level up a bit there.  This is a must-have. Okay, I have met this next creator once before. I love them. I love their content. And a lot of you do. If they weren't in this video, I feel like there would have been riots in the streets. They once did a parody of me, of which I only half appreciated, but I'm honored to have them finally officially in a video. I don't think we've done a collab before. Luigi's Mansion 3 is a game of such unusual quality. The gameplay introduced in the first game is still so solid. And it's amazing how even in a third entry, they were able to introduce so many new ideas that fit so well, they felt like they'd always been there. It's such a natural evolution of the series and it so deliberately fixes the issues most people had with the previous game. And it's such a densely packed experience. There's always something new to interact with, always a new secret to find, always a new theme to explore. You've always got to pay attention to your surroundings and every ghost has its own weakness you've got to figure out how to exploit.  I mean just like everything, light bulbs, books, papers, just everything all over the place. I mean gosh, I can vacuum up stuff just for hours. This process of vacuuming and searching and solving is endlessly entertaining. The world is a giant toy box packed with puzzles and I never get tired of exploring it. Just just never. I mean like absolutely never. Just every moment of the game is just so much fun even at this game's least exciting points. Playing it is just so satisfying and a lot of that is thanks to the graphics as well. My gosh, this has to be the best looking game on Switch. I mean it just has to. Visually it's just a masterpiece. Each location is so painstakingly designed with attention given to both visual and mechanical interests.  I mean the lighting, it's just, oh. I look at the game and I just can't believe it's running on Switch and even running well. Even during gameplay sometimes it looks like you're watching a pre-rendered cutscene. The game does have a few problems. Collecting money isn't quite as fun when you realize there isn't really anything to do with it and that the scoring system at the end of the game is kind of eh. And I do wish they'd done a little bit more to keep me hooked on Scarescraper but for what it is, Luigi's Mansion 3 is, it's one of my very favorite games ever. It's one of those games that never stops feeling great to play. I never stop being amazed by how incredible it looks and how everything works together. I truly believe that it represents some of the best work that Nintendo is capable of. How can you not love Arlo? I'm just saying. And dude and I go way back at this point. He's also super wholesome, super sweet. One of the nicest guys you'll ever meet. I didn't mean that to rhyme. And his content has grown and exploded so much since I've known this man. I also really love the game he picked. So for me, when it comes to my favorite Switch games, there's obviously a lot to choose from. There are a ton of really great first party games. There's a lot of really awesome third party games out there whether they be old ports or new games. And that's fine and dandy, but one of my favorite things about the Switch, it's the perfect indie machine. This is the best way to play so many indie games out there. So when asked this question, the first thing that came to my mind, something a little more unconventional, but golf story. For those of you who haven't played this game yet, you're really missing out. If you did play the Mario Golf and Tennis games on the Game Boy Color and Game Boy Advance, which had proper story modes with RPG mechanics, golf story takes that and just amplifies it to the nth degree. It is so absurd and amazing while still sticking to somewhat traditional golf mechanics. It's such an unforgettable experience while you are just a guy trying to be better at golf and trying to be more impressive in the eyes of your estranged wife. Along the way of getting that whole job done and trying to get all the trophies that you can, you also have to be like tossing in fish bait into the water via golf. There's one part where there are these skeletons and you have to golf eyeballs into them. There's one time where there's like these mole rats that are just infiltrating a golf course and you are asked to take these spy balls, hit them next to the mole rats, so the mole rats will take them, bring them underground, and you can find out where their evil layer is. This game is absolutely bonkers and I love that it's still Switch exclusive. Incredible. I love golf story to death. Easily my favorite indie game on the console. Go, go play it. I mean, I just want to hug him. Like you just want to wriggle to hug. Every time I see him. Speaking of people that are just, mm, huggable, it's me again. Oh, you didn't have to say those nice things about me. You didn't have to gas me up like that. Go, go super ham on the bone. What was it that he said? All right, really quickly. My second game I want to interject into this video is Monster Hunter Rise. But how did nobody pick this? The Monster Hunter series has obviously been around for a long time, although apparently not long enough for me to learn how to pronounce it. Hunter. I'll never get that. And yet a brand new release here in 2021 showed us a whole new side of the series. Introducing new mechanics that made the gameplay better than ever before. I've said this again in my review, and I did a full review of that game you can go and watch on this channel. But I've never been a huge fan of the Monster Hunter series. The gameplay was slow and chunky for me, and I really struggled to get engrossed. However, the simple addition of wire bugs and just actually taking the time to learn the game a little better than I had previously inspired a whole new love for the franchise in me. I would say Monster Hunter Rise is easily the game I've spent the most amount of time on this year. And if you haven't been paying attention, this Monster Hunter Sunbreak DLC that's releasing, it is going to be a huge expansion, essentially doubling the content in the game. And I'm very excited to see more of that. All right, cool. This video is really fun, huh? So many people. Now, for someone who if I didn't invite them, they would have just been mad at me, so they're here out of pity. I'm just kidding. Sean or RGT and I have been friends longer than anyone else in this video and I have been friends. Fun fact, RGT was a fan of mine at one point, if you can believe it. He won't tell you now, but back when I had like 5,000 subs and we first started talking when he was like 500 subs, yeah, he was a fan of Beamups. Since then, we've become very close and we have helped each other grow a lot. So what is my favorite Nintendo Switch game? I've had a lot of games that I'm like, I really like this game. I think this game is gonna be my new favorite, but there's one game that I always go back to. It might take a day, it might take a week, it might take a month, but I always go back to it because, well, it's truly my favorite Nintendo Switch game and that game is Super Mario Odyssey. Now, I feel like some of the reason I really love Super Mario Odyssey is because it just reminds me a lot of Super Mario 64. To me, that was one of the most impactful gaming memories that I ever had, just sitting there in bewilderment, looking at this 3D universe. And of course, there were other 3D Mario games before Super Mario Odyssey, with things like Super Mario Sunshine and the Galaxy games. And they were great games, maybe not so much Super Mario Sunshine, but the Galaxy games were great, but they never gave me that same sort of feeling, that same sort of amazement and wow factor that Super Mario 64 and now Super Mario Odyssey gave me like a big dinosaur that's not Yoshi. Like that's cool, a big Tyrannosaurus Rex just wrecking through levels and wrecking through different areas as you find him throughout the game. New Donk City, it's the most brilliant Mario level ever, in my opinion, because it's so simple, yet it works so well because you never expect Mario to be in a real world situation. He's always within the Mushroom Kingdom or the different kingdoms that are in the game, but he's never really been in the real world and this has actual people walking around and taxi cabs going on.   But anyways, I love collecting all the moons because I haven't collected all the moons yet and just playing around in the game. I don't want to look at tutorials and stuff like that. I want to explore and experience them for myself. I always feel like I'm discovering something new or learning something new or finding a moon and it's like, oh, that's what I had to do with this. Great soundtrack, great visuals, but really it's just a fantastic game. Definitely by far my favorite Mario game and really my favorite Nintendo Switch game to date and no, it's not because I kind of look like Mario. Stop it.  All right, next, Miss Click. I and Kim adore Miss Click. She is super sweet. She is a massive fan of Kim's, which I find so wholesome and she doesn't really make videos. She streams on Twitch very well. She's one of my inspirations when it comes to streaming and wanting to better the way I stream. In fact, Miss Click is such a streamer that she forgot to turn off her Twitch assets to record the video. She is the only Nintendo ambassador in the video. Would have been two of us, but we know what happened there. It's my turn. I do want to be quick with this because I know I can rant on forever about things. Thanks for having me part of this video, Wood and I hope you guys are enjoying all the other suggestions that my beautiful friends have been bringing to the table about their favorite Switch games. I know what you are probably going to think and you're going to think that I'm going to say something like Zelda, but to be honest, as much as Zelda is one of, if not my favorite game on the Switch, I do think when it comes to the Switch itself, I had to include the game that I have the most hours in in total. And if you know, you know, and if you don't, you're about to find out. But that is definitely Splatoon 2.  Splatoon 2 has a great story, a great setup, some of the best DLC, I think, out of almost any game I have played. I love Octo Expansion. I highly recommend that when you check out Splatoon 2, if you get a chance to, you also check out the Octo Expansion DLC. Totally, absolutely worth the money. Splatoon 2 has a set of characters and cast that enthrall you. The whole atmosphere of the world they live in is something so unique and different. You know, it might look like a kid's game, it might be super colorful, but to be honest, it's not as it appears. And though the vibrancy and the colorfulness and the playfulness of the game appears one way, the game actually has one of the best backbones for not just storyline and mechanics, but also the competitive aspect. I will say, Splatoon 2 is one of the most seamless online experiences when it comes to Nintendo Switch Online. I feel like that's not saying much, but also it's saying a lot. So if you like seamless 60 frames per second, fluid gameplay, the gyro controls are some among of the best out of the entire Switch library. Listen, if you're willing to try something new, Splatoon 2 really does well at bringing something new and something fresh to the shooter genre as a whole. I could talk forever, but I won't. Thank you for having me, Wood. Love you guys so much. I hope you enjoy all these other games that my beloved friends have brought up. Happy new year, my friends. Happy five-year Switch. I'll see you guys in the next one.  Ta-ta! Hi! Hi, Ms. Clerk. I love you. You're not me? No. What are you doing here? I'm talking to my friend. Oh, okay. Well, why are you here? Oh. Do you want to do Animal Crossing? Yeah. What is there to say about Animal Crossing that we haven't already said? I know we've done a couple videos about Animal Crossing on Wood's channel, and I've done several on mine, but I just feel like it was important to include it on the list because I feel like it got a lot of us through the beginning of the pandemic. You cannot deny that it was perfect timing for that game to come out. There definitely was a point where I slowed down playing the game for a while, but now that the updates come out and the happy- Oh, what is it called? Happy Island Designer? Is it? Oh, is it? Oh, okay. Yeah, I think you're right. I've been playing it a lot again, and honestly, I kind of like it better now than when I first started playing it because now there's items that I can actually use to make my island look how I wanted it to look in the first place. If you've never played the game and you've ever thought to yourself, I really want a chicken knight to be my neighbor. I'd really like to be in debt to a raccoon. If you'd like to collect wiggly little gyroids that you kind of wish were real and were in your own house. This was also Wood's first Animal Crossing game, so that was fun for me explaining how things work. So now I'm the expert, and he has to listen to me. That's fun. I like that. That's my favorite. That's what you think of. Yeah, okay. How do I wrap this up? All right, that was beautiful. Do you want to introduce the next person? Who's next? Peebs. We know him. Yeah. We like him. You want to say...  Okay, go. I've been a big fan of Zelda since I was a kid. In fact, I even did a video on this channel with Wood on Zelda. Go check it out. There's a little plug for you, Wood. I got your back. So when Breath of the Wild came out on the Switch, I was obviously really, really excited. I was even lucky enough to get an early copy. I was having tons of fun with it, but once I made my video and, you know, the kind of hype wore down, I started to wonder, like... The more I thought about it, the more I wondered, do I even really like this game that much? So I kind of got a little bit down on Breath of the Wild for a while, and I kind of... you know, all the talking points that you hear sometimes, the dungeons aren't that good. I actually do still think that I'm just seeing, especially right after Skyward Sword and Twilight Princess, which had some of the better dungeons in the entire series, I think... I'm just... I'm getting a little off track here.  There's no hookshot. The music isn't quite as catchy like I mean the music there's some good songs in breath of the wild of course But I guess I just kind of got used to the way the music was in the previous games Like you know you get to Dragoon Roost Island. It is like Like that there was a bunch of changes basically that made it different and made it stand out from the previous Zelda games Which I grew up playing but recently Last November actually I decided to give the game another try and kind of go in without those sort of like old school Zelda gamer expectations and just kind of appreciating the game for what it is And I'm so glad that I did because I had so much fun with it once I dropped all my preconceived notions of what a Zelda game is or should be I really changed my opinion I think it actually is my favorite switch game now. It really is a pretty crazy like 180 that I had with it I feel like everybody knows what makes breath of the wild great There's so many cool weapons that you can get there's even some of the funny ones like the hammer that you get from like That creepy monster guy it doesn't do very much damage But when you hit someone with it, they just go flying while not all the side quests are you know I his interesting as aliens coming down and like abducting cows or whatever pretty fun for the most part And there is a lot of them too. There's no tingle. Unfortunately. I really kind of wish they had No, I just want to see what they would what a breath of the wild iteration of tingle would be But there is a lot of different weird characters in the game if you delve deep enough into it There's even like a girl who's sexually attracted to like a ball Oh, and she's also attracted to Guardians you really like those I found a I killed a guardian and got an ancient rod I wonder if I wonder if she would if she would want that But anyway, I'm glad that I gave it another chance because it's it's just so much fun And there's so much there like I played the game for forever to make an entire video on it I beat the entire game and did tons of side quests and things and I still feel like there's lots of stuff I haven't done yet that I want to go back and start playing again get freaking stove for breath of the wild too I really want to play breath of the wild too. Oh, yeah, I think I'm done now though. I don't know breath of the wilds It's fun. No one on the internet has said that before. I don't think anyone can find a flaw in peanut butter gamer We've become friends very recently. It's one of them things where we just clicked our personalities are very similar I already feel like we're friends and I've barely known him six months You know, I talk a lot in this video about how much of an honor it is to Work with all these creators in this big collab and have them all in here But if you want to talk about honor, I mean, I couldn't have asked for a better wife You know, I'd hold different on a whole better honor to work with Kim in my content I mean Kim has grown into a creator of her own with her own channel But she brings so much to this channel I love that she's so invested in it that we can create things together And it's some of the most fun I have on the channel is making videos with my wife. I don't know How I got so lucky. I don't even know how this worked out and this happened, but I'm honestly so thankful I won't say who it is. I'll let it be a surprise for when the clip starts But I just want you to know that I watched that content before I had a channel and to now be working with them All these years later is staggering. This creator is OG YouTube a lot of what I create now the backbone of that was built by him and they still Create quality content to this day. They're an inspiration to any creator. What sir? Not really an Nintendo switch channel, but Don't care Hey there numb nuts.  I actually like yeah weird But if that's what you want this time, that's what you're gonna get So what is my favorite Nintendo switch game? Well, it's an epic fantasy that lets you travel to many different looking lands Collecting different weapons and doing battles with all kinds of monsters It was also on the Wii U and my only complaint is that it's too hard And you got to defeat the final boss three times who came up with that well with that said it's my favorite And you guessed it it is Angry video game nerd one and two deluxe. Oh, wait, you thought I meant Zelda Breath of the Wild Actually, yeah, that is my favorite, but how could you not pick a game starring me? It's the ultimate nerd experience when it comes to switch games. Come on. This is where it's at I mean who wouldn't want to play a game where I fight characters that have appeared in my episodes Satan, Jekyll and Hyde, even Fred Fuchs best game ever hands down.  Thank you James I want to say thank you so much for taking the time to do that for me You have no idea how much it means to me Kim and I met James once and he is also a super nice guy And the idea of doing his own game for the video was mine But if I had a game on switch that would be my favorite game on switch next I mean you can't talk about inspirations and not look at this very very sweet person I am so insanely proud of everything they're accomplishing It's crazy to me the Nintendo switch launched in 2017 and didn't get its first game until 2020 clubhouse games 51 worldwide classics. I call it a masterpiece. Others call it clubhouse games One of the coolest things about Nintendo during the switcher is their ability to bring back dead franchises without even flinching acting like nothing ever happened Most notably that happened with Metroid Dread recently But also with big brain Academy brain versus brain and while clubhouse games 51 worldwide classics felt like an excuse for Nintendo to make a We-style minigame collection without calling it a we-style minigame collection rather than making a flat-out sequel to the DS game I don't care. I miss these kind of games clubhouse games has some of the most simple fun a clubhouse games owner could ask for The visuals are so crisp and the sounds are so satisfying Just hearing a marble being placed on the table or a flip of the card the presentation is just so good And then the sheer amount of games means you're bound to like something in the package with nearly everything being available via online multiplayer As well. It may not be a perfect game Or it doesn't I'm just being coy. I really like clubhouse games 51 worldwide classics It's such a fun to pick up and play a game for the switch and it works Incredibly well as such. It's so instant just jumping in and picking a game to play There's so much content there and while most of the games aren't crazy in depth There's definitely enough modes and enough variations of each game to keep you playing You know so many of these games have been around for decades hundreds of years really That Would you get bored of them in clubhouse games 51 worldwide classics? It's clubhouse games 51 worldwide classics You always wonder is this person who they are outside their videos and I think to some degree Everyone is different, but Scott is very much Scott. He's just making videos because he loves to make videos There's nothing else to it. He just loves creating content and loves video games That's his whole thing. He's just a nice person. All right now for me one more time There's a lot still that didn't make it in the video. So let's do a couple special mentions I loved Hades Bowser's fury was a fantastic surprise Nobody picked Mario Kart 8 Deluxe and I know it was a Wii U game But it's still the best-selling switch game and one of the best-selling games of all time and deserves its credit Mario Party Superstars is Probably one of if not my favorite Mario Party and a lot of people had astral chain in their backups And I think that says a lot about the game and I thoroughly enjoyed that one But the final game for this video which makes too much sense for the kind of video that it is and I would say that other Than Breath of the Wild this probably would be my number one and that's smash ultimate I mean everyone is here in my video How could I not talk about the game where everyone is here look, you know what it is It's smash. There's not much more. I can add to it We recently had the final character join the roster in Sora which actually Invigorated my love back in the series and it's weird because I'm not a huge I love Kingdom Hearts, but I'm not a massive fan But I love the way Sora plays and it got me back into the game Competitively I even had like a two-hour stream with Bob on Twitch The other day where he was kicking my butt up and down the entire stream because that man is way too good at Captain Falcon But smash scratches a weird itch Doesn't it? I mean you can pop that game in any time and just blast out a few rounds of smash and feel content I love smash and it encapsulates essentially what this video is also trying to encapsulate bringing together all the Nintendo IPs and even just video games in a big Celebration of all things gaming This video is a big celebration of all things switch and the creators that have shown Passion and love for the console over the last five years So you can easily see this video as the top ten or a five-year celebration of the console or Just me gassing up a bunch of my friends and other content creators. However you see it I just want to thank you for watching my content all of these years and getting me to the point where I can make a Really awesome video like this where everyone Wants to be included the journey over the last five years with the switch and with my channel has been Mind-blowing and it's changed my life and it's changed me and now to be surrounded by all these wonderful people and All of you doing what I love and having fun with it. There was a point in my life Where I thought there was no fixing anything Where I thought that that was gonna be my life for the rest of my life and now I have Everything I could ever want and I couldn't have done any of it without all of your help and support I have no idea what the next five years will look like I don't think I don't think it matters if this train ever falls off the rails I will be thankful for every single moment. I had along the way If it keeps chugging along Then I'll keep pumping out videos We just know that I will always be thankful for everything


What's going on everybody? Welcome back to another video. Today we are back with another data analyst portfolio project where we will be scraping data from Amazon using Python. Now you may be asking do I need to know web scraping to become a data analyst and the answer is no. You absolutely don't need to know it, but it is a very cool skill to learn and in fact I have used it in my job in the past and so it is useful but you really don't need to know it. Something that it is used for is kind of creating your own data sets and we're going to be looking at one where you can create your own data set today but there are a lot of other uses for web scraping and I'm sure I'll talk a little bit more about that while we're actually walking through the project. One last thing I want to say before we get started is that this is most likely an intermediate project so if you are just now learning the basics of Python this might be a little bit challenging for you but I still recommend going through it because I will do my best to walk through everything every single step of the way and kind of explain all of the concepts and so you can still learn something even if you aren't super good at Python right now. With that being said let's jump over to my screen and get started on the project. All right so we are going to get started and if you didn't watch the last project I had people download Anaconda. We use Jupyter notebooks and I'll show you how to get to that in just a second but I'll leave this link in the description if you haven't done that already and you're just doing this project but you'll go you'll download Anaconda you know download it's super easy and you're gonna open up Jupyter notebooks I'll launch it right now I already have it open but I'll open up another one just for you know the purposes of demonstration. What we are going to do today and what we what people voted on I mean there's like there's like 8,000 people that voted in the poll that I made of what data you wanted me to scrape there was like Amazon cryptocurrency weather something else I don't remember overwhelmingly I mean like 70 percent of people maybe even 80 percent I don't don't fact check me on that voted for Amazon and so I'm going to do it now there are many things that you can scrape off of Amazon just a ton of stuff and I am going to show you how to do it I'm going to show you how to make it useful how to make a data set and it's going to be really interesting but there are lots of other ways to do this and so I think and I have already kind of created it I'm going to show you how to do it off of this page when you're actually in an item and you can scrape you know basically anything in here and I'll show you how to do that another thing that is a little bit more advanced and that's why this first video is starting off I think on the more easy side it's not easy but it's easier the next thing the next video that I'm going to make is how to actually do basically do multiple items right so this item this item this item this item and then traverse through the different pages so there's 20 pages you want all of that data how do you get all of that that'll be the next project I don't know when I plan on doing that I have it like 90 percent of the way done but I have this one completed and so I wanted to get that out to you guys now but that'll probably be the next project I think that is much more difficult and so if you can understand this one and you get it and you understand it then the next project you should be able to understand too it's just a little bit more complicated so with that being said we are going to actually get into the project I'm going to delete one of these all we're going to do is go to new do python 3 it'll open up a new one we'll call this Amazon web scraper project that's what we'll call it nice ballerite perfect the first thing that we need to do or that we should do is upload or import our libraries so I'm going to say import oops what am I doing off to a terrible start there we go import libraries now I'm not going to write on all the libraries I have some things that I'm going to be copying and pasting throughout this I won't there's only a few things that I'm copying pasting you take a quick glance some of the things that I just don't want to waste time on because this could be a long video I don't know I don't always time on stuff like this and so you know I'm just going to copy and paste it you guys are going to I'm going to there will be a link below if you haven't clicked already that will go to the github page where you can literally have all of this code already written I do recommend writing it all yourself because you will learn it much better I promise because then you'll make mistakes and you'll figure it out and all that all that good stuff but you will have that code available so just go copy and paste it that's what I would do but what we are we are going to be using today is something called beautiful soup requests then we're going to be using time and date time and a potential one if you want to get and I'm going to show you this at the end this is not really part of the project it goes above and beyond but this library right here is for sending emails to yourself and I'll show you how you can use it if you want to I already have the whole code written out you can just steal it and try it out yourself and see if you can get it to work but this one is not as important I'll put it down here so let's move on now one thing I want to say before we get too into it is that well give me a second is that right here in front of me is a different laptop now it took me a solid I would say you know 10 hours or so to write all of this it took over the course of like two weeks in my free time I'd pick it up it took me a solid you know two weeks on and off an hour here an hour there to finish this project and I made a ton of mistakes and messed a bunch of things up and I finally got it to work you know after a bunch of revisions that's typically how things go when I do projects and so I'm about to give you a streamlined version of this because I have all the code right down here and so I'm going to be glancing at this a lot just so I don't make this video 20 hours of trying to remember all the code off the top of my head I have it written out already I already did the project it works it's beautiful it's a good project so I don't want to waste your time and I just want you to know that you know you nobody should be able to do this up top their head in an hour most people want it takes time you make mistakes but let's get started on the project now in this in this what we're going to have to do is we're going to have to tell beautiful soup and requests where we are actually getting this data from what websites what is our computer you know some information from our computer I'm gonna again there's gonna be a little copying and pasting in here because you don't ever you will never ever ever need to know this but right here we're going to basically connect to the website so I'm just gonna say connect to website and we're gonna say URL is equal to and let's go get our URL so we have this right here so literally just go up here do you know control a copy that oops that's the actual project get rid of that paste it in here and that is our URL we will use that in just a second what am I doing you just get some room here and then we what we're gonna need is something called headers now again you will never ever ever need to know this so I'm just gonna say headers what I'm gonna do is I'm going to copy this I'm gonna show you how to get this really quick but is something called headers so let me show you how to use how to get this and why you don't need to know any of this so what this headers is is this something called a user agent you need to do this for your computer and you can do that by going to this link right here so I'm gonna put this link in the description so that you can go and get that and there's something right here called the user agent so all you have to do is copy this just like this do copy I'm gonna go back here and I'll show you that it's I'm gonna copy it in it'll be the exact same so there you go it's the exact same all of this extra stuff except encoding except this HTML stuff connection close all that you don't need to know any of it I promise you'll never come in handy ever in life actually there will be one person who that becomes in handy for and then they'll message me but we are now connecting using our computer using this url and then what we want to write is you want to write page and we're gonna say equals and this is where we start using these libraries so we're gonna use requests dot get and we are gonna pull in that url and we're just gonna say headers is equal to our headers right here so we have this and this is where we're gonna actually start getting the data bringing in the data and it's not gonna look like that at first but I'll try to print some stuff out as we go along the way so that you can kind of see what it looks like and how we're gonna kind of make it more useful because it comes in very dirty when we first get it and some of the things I'm gonna show you will just help clean that up and before we actually go any any further I don't want my head to be here for the entire time I'm gonna get rid of myself so you can just see the page I just it's less distracting I hate when I feel like people are always watching me so I want people to just focus on the code so I will see in a little bit let's get back into it all right so what we are going to do is we are actually going to start using the beautiful soup library all right so we are going to say soup one is equal to and this is where we actually start bringing beautiful soup and you guessed it you're gonna say beautiful soup and then in parentheses we're gonna do page dot content and again these aren't really things that you need to remember or need to memorize we're just pulling in the content from the page that's really all we're doing right now and it comes in as html so we're gonna do html dot parser and let's see if I can print out actually let me just do a soup one I don't like I don't like doing uppercaps on stuff let's see if anything prints out real quick so we are literally pulling in all of the html and let me go show you really quick because we're gonna get to this in a second anyways if you come here this is this is a static page basically written in html um if you have never seen html before um you know actually a lot of this is you know just stuff that most people will never use it's just good to know some of this stuff is good to know so as you see I'm scrolling on this right side by the way I did right click and inspect or control shift I whichever one works better for you but as I'm scrolling over this you should see it kind of highlighting different areas um it's hard to kind of get what you want let's say we want this title um what I can do is I can click select element go right here um and then we can select like a type that the the header or the title of the the page now I just want to show you though of what we're pulling in so we're pulling in this doc type html all of this is coming in so that's what this is right here this doc type html and we're pulling every single thing in that is what we're doing right now so let's get or let's go down a little bit let's do soup two we're just going to do a very uh you know uh an upgrade to soup one basically we'll do beautiful soup again and then we're going to do uh soup one so we're pulling in that content again so that's soup one and we're going to do dot prettify if you don't know what that is it is common in a lot of different languages and a lot of different stuff um it just makes things look better it that's really all it is I don't know why I'm using double quotes I don't know why I can you can do single ones if you want and now let's do beautiful soup two and it should just be a it should be better formatted and let's see if that's true and it is so before if you did if you can tell it what it didn't have basically any formatting it has a little bit of formatting now it'll help in a second and you'll see that but now what we want to do is go back and want to actually get the data that we want now you can get any data you want I'm going to show you simple things really really easy um in my in in my opinion it gets more difficult the more complicated stuff you start pulling um and and you'll understand that as we go into it so what I'm going to do is I'm going to select this and I'm going to select this um the title I want that and so if you do spam id it's equal to product title so you need to remember that um class we don't need to know class I believe we're going to be using that id this id equals product title so that's what we're going to be using um class will come in in the next video we start looking at these but not in this one so let's remember id equals product title so let's go back over here so we have this soup two it's basically all of that html in right down here that is what we're pulling in so we need to kind of specify what we actually want so let's say title that's what we're going to be getting um and we're going to do soup two so using taking all that content um and we're going to find and we're going to open parentheses and we're going to say we want to find that id where it's equal to product title and then we're going to do dot get underscore text and then we're going to do open parentheses so now let's um let's print the title and see what we get all right so that is exactly what we're looking for it's funny got data mis um t-shirt that that is what we're trying to pull in so it's perfect that's exactly what we want we don't uh let me let me just do this save me some time later on we don't only want the title we are also going to be pulling in the price so if you can guess uh we'll be doing some uh a data set on the actual pricing um and so let's go back here we're going to again use this right here and we're going to go to this price and it says again we're going to look at this id the id equals price block underscore our price so fairly easy you can copy this i'm just going to write it out um we're going to say price is equal to soup to dot find and then it's going to be again id is equal to and then it's going to be price block underscore our price did i sell it right excuse me there we go and the exact same thing dot get underscore text parentheses uh and there's a get text there's a get all or get all text um so you know that get text is a specific thing that we are using you know we might use a different one later on um but that that is what we have so now let's let's print the title and print when i have all this too much uh too much space so let's print the title and print the price now let's see what we get okay so we have our title and we have our price i mean you know i don't know what all this white space is over here um but it looks like there's a lot of white space over here we'll have to get rid of that uh in a little bit as we clean it up a little bit you can if you want do things like um you can get and this is up to you i'm not going to do this right now but i'm just going to show you how to do it you can get this where you're pulling in the ratings um which is you know if you want to look at like how the ratings over time or what ratings are for specific products that could be really useful um you can pull basically anything you can go down the product details and look at dimensions uh anything you want on this page it is static so you can go in here and pull anything it's just have to pull it from the html know where you're looking pull it in and now when we go back here excuse me i'm going to show you now kind of how to use this right because we have this but how are we going to use it that's kind of the important parts i think first thing we need to do is clean this up a little bit because it just is you know if we try to use this it wouldn't be super useful because it'd be just a little bit dirty it's not super clean um so what we want to do is let's start with the price why not we're gonna say price dot strip um and that's just going to take uh basically the the junk off of either side and so let's run that real quick so this is what we have but what we can also do is i don't want that dollar sign i just want the numeric value um later on we are going to be putting this and we are going to be um creating a process to put this into an excel file again we're trying to create a data set i don't want you to have to copy and paste stuff is all going to be automated basically to input this data into an excel file for you or a csv file for you so um you know think about making it useful in a csv or in an excel later on so what we can do is do a bracket and we're going to do one and then everything after that so basically it's just going to take everything from the first position onward uh so let's run that and there we go so let's just say price is equal to price dot strip um and pull uh just do everything after that first um that first that value am i saying what's the word for that i can't remember the word the first space that's not the right word but all right let's do the title this is basically going to be the exact same thing um super easy so we're just going to do title dot strip and open parentheses um and we can you know if you want to do this exact same thing so now we have it it's a little bit cleaner so this is what it originally looked like and now this is what it looks like so you know nothing super crazy but you know something interesting to know now we are about to in the very next part what we are going to do and let me just add a few of these because it makes me feel better um what we are about to do is we're going to create our csv to insert this data into the csv and then later on what i'm going to do is show you kind of how to um automate this process to pull this data um to create a data set right just pulling this one time and putting it into a csv really doesn't do anything you can just copy and paste that and save yourself a lot of time um what i'm going to show you is is um basically doing it over over time and just having it automated in the background that is what i'm going to show you um i guess a spoiler but what we need to do is we need to create uh create the csv insert it into the csv and then create a process to append more data into that csv um i'm doing a lot of talking let's do some writing so what we need to do is we're going to use um i should have done this at the top maybe i'll go back and add that later on we're going to do import csv now in a csv what you want is you want headers and then you want the data right so for our headers and we're going to call it header we're going to do um we're going to do a bracket and let's make the first one a title because that's going to be we can call it title you can call it product whatever you want i'm just going to call it because i've been using title i'm going to call it title um and then we'll also have price now we need our data so i'm going to say data is equal to now this is important um right now how our data is and i can do this right here and type um title or now let's do type price so these are strings and that's important to know um again i don't want to get too much into you know dictionaries arrays and lists and strings and all these things but this is a string and you can't put that right now it's not super usable what we're going to do is make this a list um and so i'm doing an open bracket and i'm going to say our data is title comma price oops price now oops if i do type oops of data i'll just run that it's a list now and this is important because you can run into a lot of issues of this stuff it's really important to remember what's what type um how do i say this uh how your data is is it a list as an array is it a dictionary um you know what is it these things are important they do play a big impact especially with this type of stuff so just want to show you that really quick but what we are now going to do is create a csv um you're going to create an excel i call an excel csv you know whatever you want to call it so what we are going to do is we are going to say with and we're going to say open and now we're going to name our file you can name this whatever you want i'm going to call it amazon web scraper dataset that's real long dot csv and then we're going to do underscore w and that means right um oh whoops that's not right just like i was wondering why that was in black uh so we're going to do w which means right um and then we're going to do new line if you don't know what new line is uh all that does is when we insert the data it doesn't have a space in between each csv and then we are going to do encoding is equal to oops is equal to utf 8 and that is it and we'll just say as uh let's do f so some of that stuff you don't need to know some of it's useful this w you definitely need to know this new line is is good to know and um i'll take it i might take it out just to show you what it actually does because it's annoying if you don't have it i promise um but you know that that new line's important as encoding you know good to know i think that's my default is it's like that uh anyways what we're going to do now is we're going to uh it's something within the csv within the csv library so we're going to do something called csv writer and oops csv dot writer and we're going to do open parentheses and that is that then we'll just call that writer and then we'll do this is where we need to actually create the header so uh we're going to do writer is dot sorry writer dot write row and this is just for the initial um the initial import or not import the initial insertion of the data into this csv this is what's important the next one that we're going to write is for when we're actually appending the data which is going to be a little bit different but anyways we're going to do write row open parentheses and this is where that header is going to go so we're going to the these headers are going to be the title and the price and then for our last one we're going to actually write the data which is this data right here and we're going to say writer dot write row and we're going to do data so this one we're creating the csv and then we are inserting the header and inserting the data so super easy um yeah I think that's fairly straightforward right now let's do this and let's see what happens so I just ran it let's go over here and here's somewhere amazon web scraper dataset let's open that up and there we go oh geez this isn't good can't verify my um my subscription uh why does it say 699 uh I'm gonna go back and look but I think I know the issue but this is exactly what we want now of course we want more data and maybe a little bit more useful data um and I'll show you how to get that in just a second but we just created that out of thin air uh that was not I didn't have that saved before so we have this dataset and the issue was is that I ran this multiple times so now it's 699 if I do it again it's 99 uh and if I did it again it's you got it gets rid of everything so I'm just gonna run this again run this again now everything's back to normal okay so now if we run this it's going to overwrite this amazon web scraper dataset.csv and it will put the data in properly so there we go oh geez guys this is embarrassing I'm embarrassed no I don't want this okay perfect um yeah guys I if you can't tell I'm in need of some um I'm in need of I'm in need of some help here but I'm just kidding I'm doing I'm doing fine uh I just I don't know why that uh I don't have my uh subscription activated it's not gonna matter for this video I guess but that's really random um so we got what we need that's perfect now what we want to do after this um I I guess actually what is important is some more useful data something that I like to do a lot when I do this type of this type of stuff is I like to have some type of date stamp um or some type of time stamp to know when I collected this data it usually comes in handy later on um I I have never regretted putting it in there I'll show you really quick how you can do it you can do import date time geez I hate having to format stuff like that and what you can do is you can do date let me get date time and you do dot date dot today open parentheses and that is going to give us this right here uh and so we're just gonna do um today that's what we'll call it is equal to this and we'll say print today and there we go so that is today's date is the 21st of August in 2021 so today is now um is now this so actually I'm gonna get rid of that I'm gonna put it back up here I'm going to put it right there I'm gonna run it again let's add this right here we'll do um we'll do we'll call it date and then we'll add today and we'll just run this again and what we can do just to check the data without having to open up the data every single time which is super annoying is we're gonna use pandas again I should have imported this at the top I'm just kind of uh I'm not doing this off the top of my head but uh I didn't have it 100% planned so import pandas and we're just gonna say pd dot read underscore csv and then we'll read it in um what you can do or what I often do as I go to properties and I go right here do do do and we'll say boom boom back slash this right here this I am doing off the top of my head I don't do this often I think I have this memorized by now uh I I I hope and then we'll print oh no we don't have to do print we'll just do this uh what I do are uh let's all actually call this um data frame and we'll do print let's see what happens perfect okay so what we have now is the new our new header our new data that we added in there so we have our title we have our price and we have our date now again you can customize this whatever you want to add go back here um you know find what you want you know do you want it to make sure it has a men's option or different colors or you want to pull in this information whatever you want it really does not matter um just matters that you know you get what you need for whatever purpose whatever you're making this for this is more of an introductory video to how to scrape data from amazon um the next video will probably be a little bit more difficult and in depth but this is kind of let's get you guys started so um we now have this and this is beautiful now something that you want to do when you're scraping data and you're getting um I guess data over time and that's kind of what we're doing we're it's going to be almost like um at price tracker over time is you want to then append data to this so we can't only create it that's what this does because if I run this 100 times it'll only give me this first row we need to now append data to this so um let's let's pull this down here again I'm I'm not I haven't added a bunch of notes I'm gonna say now we are appending data to this csv I haven't added a ton of notes I'll try to go back maybe afterwards and add some notes for people who like to read notes um so what we are now going to do is we're going to change this w to an a plus now this is going to be how we append the data um and we no longer need the header so we don't aren't going to do the header anymore and there we go so now instead of excuse me so now instead of creating that header again creating that first row of data again we are ignoring the data and we're now going to the next nearest free row and appending data which means to add on data to that um and so if I run this which I'm not going to right now oh I mean why not I can I can run it um and then we can read this in it so now there there's our data I'll run it a few more times I ran it like three or four more times I run that in and there we go now it's all the exact same data super um boring but very very uh you know good to have now we don't want to have to come in here and run this every day let's say we're going to do this daily um we don't want to have to come and right run this every single day right we want a way where it does it while we sleep it does it in the background of our laptop um it is easy to do right I don't want to come in here every single morning with send alarm on my phone every single morning come in here I want to automate this so uh how are we going to do that give me one second uh if you didn't know I have three kids and one of them is waking up I'll be right back all right I think he is asleep um at least let's hope he's asleep so now what we're going to do is we're going to put this all into uh this check underscore price now you may never have used oh geez what are these things called oh my gosh super used all the time you'll know what I what it is uh a function I don't even remember what it's called maybe this is a function um I can't think I'm having like a writer's block or whatever that is we're gonna put it all in here and then we're gonna be able to use this price check later because we want to be able to automate this so let's go back all the way up here we are going to use this so let's copy all of that in and oh geez I hate this all right everything just like that um so this pulls in our data pulls in uh or yeah pulls in all of our data down to the title and the price we want to make it look right so we're going to put it right here so now we have it formatted properly um we want to add our date time just like that I don't know if there's a better I'm sure there's a better way to do this um then we need this right here and just like that like that so now we have our header and our data and then we want to pull this in right here boom boom boom okay so everything that we just wrote out we are now putting into this check price now you can call it whatever you want doesn't matter but let's run that see if we get any errors we don't so this is now good to go basically um what we are going to use this for um and what this is going to do is we are going to put this on a timer um you know have you ever wanted to like check something once a day once every 10 seconds once a minute whatever you want and you don't want to have to actually pull up your phone and look at it this is how we are going to do that so we had something called uh let's see time this this this library time right here that's what we're going to use right now so we're going to say wow oops wow true and go like this do a colon we're gonna say check underscore price that's what we just wrote out and we're gonna do time dot sleep now this is completely up to you how much time you want to put in here for the purposes of demonstration i'm going to put five seconds which means every five seconds it is going to run through this entire process and so let's run this really quick and i'm going to run it for let's say 30 seconds and then i'm going to pull this in right here so we just looked at it earlier we had four um no five rows of data right what we are going to do is in just a second i'm going to stop this you know maybe after 30 seconds or so and we're going to see how much data is in there uh and let's stop right now it's been going far enough um and now let's run it so now we have five six seven eight so i guess i ran it for 20 seconds we can that was for demonstration purposes i've never do any some anything ever every five seconds um unless it was like black friday on amazon we can put this as long or as short as you want you can run it every second if you want um that doesn't make sense to me but you can what we can do is do a little bit of math uh and i don't know this off the top of my head so i'm going to uh do the math with you live pretty exciting stuff got the calculator out so there are 60 seconds in a minute and this goes by seconds by the way and you could do you know you can do some um some string up here i'm calculating this but i'm just going to put in the number because it's easier maybe not easier i'm just going to do it there's 60 seconds um in a minute there are 60 seconds or 60 minutes in an hour so that's one hour uh and we can do 24 hours in a day so that's 86,400 i believe did i read that right oops did i read that right yes so this now if i ran this and i'm going to this is going to check the price every single day and this is the entire point of this um of this project not the entire point but this is a big part of this project is we want to create our own data set now something that i personally really love is a data set that has you know that i can do some type of time series with now this is not exciting it's probably not super exciting for this right but you get the idea that if this price were to change we would then see that reflected in the data at some point you can do this on any item you could ever imagine on amazon is the exact same process and some items change often this t-shirt will most likely never change um and so you know again this is for demonstration purposes the code itself will be nice to put in a project although the data set that you get from this probably won't be the best i would imagine but notice that this is running um i can then minimize this and this can run on my computer basically as long as my computer uh is is working um one thing i will say before i go on to some more stuff one thing that i will say is that i personally when i did this for a when i um created this i did something similar and i put this in visual studio code and i didn't put it in jupyter notebooks that's a personal preference i would look into that if that is something that you want um i think visual studio code is a little bit easier for automating these types of tasks um but for illustrative purposes and for demonstration purposes you cannot beat jupyter notebooks that's why i did it so with all that being said that is basically the end of the project now um i'm not going to stop this and read it again but you get the point we now have um a data set that oh geez all this again that now has um data i'm getting out of here oh geez it's hounding me let me get out of here oh no all right this is embarrassing guys i'm embarrassed we now have a csv file with data in it now you run this in the background of your computer you can do that i have done it i've ran it for weeks i have ran it for months um if you restart your computer just come back in here and restart running this process um it's the same for any automated process unless you start using some online um automation service which will run it regardless of your computer they do it you know either in the cloud or on some um server so you know that this is a really good option again if if you restart your computer or something happens you lose connection just come in here run this through the script again um except for the one where it deletes all your data don't run that one again only run that one time um and then you will and in fact what i would do is then um i would just comment this out right i'd come in here and i would just comment this out so that anytime i come back in here i would never accidentally delete all my data but that is what this project does now something really interesting something that i have done in the past that i thought was really cool really useful i actually did it for um i actually did it for some watches that i was watching especially on black friday it's when i used it i was interested in a price drop or a specific price change and what i did was as i said and i don't know so what i basically did was is i said if the price is lower than let's say let's say we want it to drop below 14 dollars it would then send an email um and i'm going to show you the script that i used it still works um and if this is something that you are interested in this could be a completely different project i just think it's interesting and i wanted to show it to you although i wouldn't say this this is part of the final project let me just come in here and we are going to create this super simple um on that super simple we're sending a mail we're connecting to a server we we're using gmail we're logging into our account that is my email you will not get my password we're creating the subject the body we can figure or just kind of create this message and then we send a mail so then i have this define uh or this send mail i i'm blanking on what this is called i'm gonna call it a function but that's probably not right so if that price drops below a certain point it'll send me an email um i have used this and i used it and was able to buy a watch that was like you know let's say 140 bucks for like 90 bucks um on a black friday sale i was really really happy about that so this can be used in that way as well um not something you have to write into your project just something i'm going to include down here if you want to try it i think it's super interesting something really fun um really fun to mess around with i enjoyed this so with that being said uh this is this is the project um i in the next one and i promise you this one is probably going to get a lot more difficult if you thought this one was easy which i hope maybe i hope you do then that means you're you know pretty good at python you know in the next the next um web scraping project and i hope to do many of these i might do um even all the ones that i put in that poll but i started with the one that was the most popular um you know if you were able to get through this i think that that is fantastic i think this is a solid project to create um a data set and so use this how you will you can copy my code exactly i don't have a problem with that again i don't think this is beginner there are some a little bit more advanced things and i don't know in advance just like intermediate level things um that you kind of learn as you get into it and so i hope that this was instructional i hope that i explained it you know well um and i hope that this is useful again you know when you actually use this you'll have 22 23 24 25 you know you'll see a price change a price change a price change a price change go use a product or go to something that you were interested in or you think you know fluctuates often um and there are plenty of those on amazon i promise there are some that literally change almost every other day like down a dollar up a dollar um and then black friday just goes crazy with these price changes so use this as you will i hope that this was an instruction i hope that it's useful i think i said that before is i you know i i'm doing this because i think it's really interesting it's really useful um this to me again was a good introduction a really good introduction to web scraping because in this next one it gets quite a bit more difficult um i would say on a scale of like difficulty this is like maybe a four and it'll probably jump up to like a seven on this next one um just just much more technical or coding heavy so um you know look forward to that if that's something that you look forward to with that being said i'm gonna go back over here for my send off with that being said i hope this was helpful i hope that you learned something um don't get mad at me if it was too easy don't get mad if it was me if it was too hard uh i'm doing my best over here so i appreciate your patience thank you so much for watching i really appreciate it if you like this video be sure to like and subscribe below and i will see you in the next video