Pass a URL to the pd.read_csv Method - Data Analysis Tutorial

Pass a URL to the pd.read_csv Method is a free tutorial by Boris Paskhaver from Data Analysis course
Link to this course(Special Discount):
https://www.udemy.com/course/data-analysis-with-pandas/?ranMID=39197&ranEAID=Gw%2FETjJoU9M&ranSiteID=Gw_ETjJoU9M-.011Kwrka2VdAqp4u2Fgpg&LSNPUBID=Gw%2FETjJoU9M&utm_source=aff-campaign&utm_medium=udemyads
This is the best Data Analysis Course
Course summary:
Perform a multitude of data operations in Python's popular ""pandas"" library including grouping, pivoting, joining and more!
Learn hundreds of methods and attributes across numerous pandas objects
Possess a strong understanding of manipulating 1D, 2D, and 3D data sets
Resolve common issues in broken or incomplete data sets
English [Auto]
In this lesson we'll take a look at how we can pass a r out to the read CEV method to get pandas to download a data set for us from the Internet to our local Jupiter notebook. So what is the advantage of this. Well imagine you have a online link that stores a dataset that is frequently being updated. For example you may have a CSP that is being written to buy a database every hour or every day. So we have a dataset that is always changing and it helps to have the latest version of the data. Well in that situation it becomes very laborious to go to an online link download the data set locally make sure you don't confuse it with another one and then import into your notebook and all all that stuff. It takes a lot of steps. It's a lot easier if we can just provide a link to that CSP. The location on the web where that CSC file is located and as it's being updated whenever we run the panda's file or the Jupiter notebook file it will always get the latest batch of data. Let's take a look at how we can pass a euro to the reader CSP method. It's gonna be a simple string. So in another tab I have the New York City Open Data Web site. So this is public data available from the city of New York. You can visit it at Open Data dot city of New York dot U.S. so one public dataset that is made available by New York City is baby names. What are the names of the babies being born in Europe. So here I can search for the baby names dataset and the very first result we're going to get here is this one popular baby names so let's click on that and once we're on this page we can go ahead and click View data to see a preview of the dataset so here is a sample preview of the first couple rows. And I don't know the rate at which New York City updates this and maybe daily and maybe monthly but it would help if we had a link to this data in its online format so that we would always get the latest batch. So if I click this export button right here you'll see we have a whole bunch of options including CSC. And if I click it right now it will download the CSP file. But this is stored on some server somewhere. And if I can just get the URL of the CSC then I can also pass that into my read GSP method. So what I can do here in my web browser is right click on CSC and select copy link address. So if I paste that link address in your old bar you'll see it's the actual link to the location of the CSP file. Right here we can see it's called Rose dot CSP. In fact everything after we don't actually need. So we can delete this. So I'm going to copy this your link to a CSP file on the Web. And right here I'm going to declare a variable called the URL and I'll assign it to a string containing that euro. All right. This is a link to that dataset. So now all I need to do below is invoke the read CSP method like always. But now instead of providing a file name of a CSP that is found in the local directory I'm going to provide a string representing a link to a CSP on the Internet. Like so. So when I execute this it might take a little bit longer to process because it's going to need to make the web request and then get the data. But what we get back here is a data frame. So Panisse has reached out to the online dataset on the city of New York website fetched it and then converted the CSP data automatically to a data frame. And of course if we want to work at this it's as simple as assigning it to a variable like baby names. So once they execute this we have the data stored locally and I can for example preview the first six rows of the data frame with the head method. And there we go we've now fetch the data locally. So for example if tomorrow there's 10000 more rows added to the CSP it's not a problem. This line of code is a lot more dynamic and flexible. It's going to fetch the latest batch of data and we don't have to download this dataset locally. So super powerful and super helpful when you have a dataset that is changing constantly. We're going to be reusing this baby names data set throughout a couple of the lessons here so hold onto this code. But other than that I will see you in the next lesson.
Pass a URL to the pd.read_csv Method In this lesson, we pass URL