Super helpful as always @Alex . Love that you didn't censor the glitches, errors, and obstacles and instead explained that it's a reality and described how you deal with it. This is as helpful as the technical aspects.
I surveyed TH-cam looking for a practical explanation to this topic, this one is the best ever. I just found what I was looking for after being frustrated and depressed. Thank you so much Alex
Nice video 😀… You had to restart the kernel once you have changed the data rate limit. Just in case anyone does not know, you should restart the kernel after installing a package from the pypi using the pip/pip3.
If you are having the IOPub data rate exceed error here is something I noticed. First, make sure that Jupyter Notebook is updated in the anaconda navigator. Second, run the command that Alex shows inside the Anaconda Powershell Prompt. Not sure why that specifically works but it works
Thank you Alex, I started to believe its not important what you do, most important part is how you do. And I can say, you doing great! So useful and informative video! Thanks a lot
Where re you learning the SQL. I have been kind of wondering where best to learn that at a relatively cheap amount or free. Priority is largely on sound education
Hey Alex, I have been meaning to get my hands dirty with the API and now I feel a bit more confident in testing it out and seeing it for myself. Looking forward to the API Project.
I love how real this video gets when the unexpected error occured. Obviously everyone has encountered something similar and things don’t go as planned! 😂
Thank you so much Alex! this is Super Helpful! I'm trying to pulling up data using API with python before and I got stuck . But, thanks for this video. I'm ready for the next step
Hey Alex, I can't thank you enough for all the useful videos and resources you share. Thank you so much for all your efforts. I have learned a lot from your videos and still learning...!! keep doing the great work.
Hi Alex Sir I actually want to ask very important question about the interview its almost asked in all Data analyst interview. Question is that Interviewer asked that if you have less time and your analysis will take more time so in this case what should you reply to your stakeholder
In the future, can you please use a black/contrast mouse cursor with a bigger size. The white one is really hard to track for those watching on a TV. There are dozens of us.
Okay, so question here - I was taught to add my importa all to the top of my code, even when I figure out that I’ll need it later on in a project, so that folks can see what I’m using all in one place. I was shocked 😮 when you added yours below some of your live coding. Do you have a preference or is it not something you think about? I’m asking because I’m trying to learn the best practice - if there is one
Depends on the situation - like you said you may not always know and adding it later isn't a big deal. I do typically try to put them all at the top though :)
Hi Alex, I also faced the same problem but I'm not able to solve it since I was using Colab. It would be very helpful if you could help me resolve this issue.
Hey Alex, Firs off, I love your videos! second, I am having a issue. Once I updated the data rate limit, it worked briefly and then my ipykernel could not reconnect. did anyone else have this problem or know how to fix it?
I know this is old, but I'm getting a "Missing api key", even tho I used the same code as the doc, video, and tried different versions. When I test it in postman, it works fine.
Dude I work with anaconda environment and doing that or deploying something is impossible. I think it is because I don't have Python installed on my PC, as I said I use Anaconda, and I installed Python in there.
while running the below code, I'm getting a message saying Key error: data pd.json_normalize(data['data']) Would be helpful if someone could point out the solution for this
@@nuraiymsardarbekova6509 I had the same issue! I used this guys tutorial th-cam.com/video/B_YlLf6fa5A/w-d-xo.html&ab_channel=emaadmanzoor its for windows but worked for me on mac. you need to access the hidden folder for jupyter (command + shift + . ) when looking in the root folder. then in the jupyter notebook config file you change the data limit and un comment out the code.
@@nuraiymsardarbekova6509 I figured it out. Close you jupyter notebook and the jupyter bash terminal. Open a new terminal window (not a jupyter terminal just mac terminal) and copy and paste alexes command in there. It will open jupyter notebooks with the new settings and it will work.
Super helpful as always @Alex .
Love that you didn't censor the glitches, errors, and obstacles and instead explained that it's a reality and described how you deal with it. This is as helpful as the technical aspects.
I surveyed TH-cam looking for a practical explanation to this topic, this one is the best ever. I just found what I was looking for after being frustrated and depressed. Thank you so much Alex
I got stucked for about 30 minutes trying to connect it to DataSpell. It worked, now I can leave the tutorial with peace :D Thanks!
After increasing the data limit, I just closed everything and opened the notebook again and it worked fine :) Thank you for your videos!
Alex you are the best data science TH-camr in the world. Thanks for the great content we truly appreciate it.
Nice video 😀… You had to restart the kernel once you have changed the data rate limit. Just in case anyone does not know, you should restart the kernel after installing a package from the pypi using the pip/pip3.
If you are having the IOPub data rate exceed error here is something I noticed. First, make sure that Jupyter Notebook is updated in the anaconda navigator. Second, run the command that Alex shows inside the Anaconda Powershell Prompt. Not sure why that specifically works but it works
It didn't work for Jupyter Lab, currently stuck in the mud.
@@godfreyodhiambo4531same
That's just awesome ...... Eagerly waiting for full project
Thank you Alex, I started to believe its not important what you do, most important part is how you do. And I can say, you doing great! So useful and informative video! Thanks a lot
Just at the right moment it has arrived when I am just started learning SQL.Thank you sir, you are awesome.
Where re you learning the SQL. I have been kind of wondering where best to learn that at a relatively cheap amount or free. Priority is largely on sound education
I am also learning SQL
@@MoHSinALi-xt5ib Where please?
@@ezekomaugoo5569 and also playlist available on this channel
Hey Alex, I have been meaning to get my hands dirty with the API and now I feel a bit more confident in testing it out and seeing it for myself. Looking forward to the API Project.
Loved it! I started TH-cam recently and I'm still small, but you are one my main inspirations for taking this step. Keep doing what you do!
I love how real this video gets when the unexpected error occured. Obviously everyone has encountered something similar and things don’t go as planned! 😂
Good video, this will help people get over the scary barrier of an API.
Thank you!
Thank you so much Alex!
this is Super Helpful!
I'm trying to pulling up data using API with python before and I got stuck .
But, thanks for this video. I'm ready for the next step
Nice video, thank you! Looking forward to the project video(s) that you mentioned!
That was like magic, I can't wait to learn all this
Cannot wait for next video :)) Love your tutorials
Thank you for uploading this. It was worth watching
Very informative Alex! Thank you!
Hey Alex, I can't thank you enough for all the useful videos and resources you share. Thank you so much for all your efforts. I have learned a lot from your videos and still learning...!! keep doing the great work.
Good training. Thanks for putting this together.
This is great!
I would like to ask, did you learn these things on the job or before?
I learned how to use APIs on the job
Thank you for explaining it so well.
Hi Alex Sir I actually want to ask very important question about the interview its almost asked in all Data analyst interview. Question is that Interviewer asked that if you have less time and your analysis will take more time so in this case what should you reply to your stakeholder
Thx for sharing cool video!
Thank you so much, Alex!! It is really intriguing for me. I cannot wait for the further relevant projects.
You're more than welcome! I'm looking forward to it too! Next week should be a fun one :)
In the future, can you please use a black/contrast mouse cursor with a bigger size. The white one is really hard to track for those watching on a TV. There are dozens of us.
Okay, so question here - I was taught to add my importa all to the top of my code, even when I figure out that I’ll need it later on in a project, so that folks can see what I’m using all in one place.
I was shocked 😮 when you added yours below some of your live coding. Do you have a preference or is it not something you think about? I’m asking because I’m trying to learn the best practice - if there is one
Depends on the situation - like you said you may not always know and adding it later isn't a big deal. I do typically try to put them all at the top though :)
Gotcha! Thank you 🙏🏾 @@AlexTheAnalyst
Alex please, who offers the best course on SQL?
Hi Alex I wanted to ask you a question. Can you become a data analyst with just a FinTech degree? And do you recomend getting one if so? Thank you
Hi Alex, I also faced the same problem but I'm not able to solve it since I was using Colab. It would be very helpful if you could help me resolve this issue.
thanks
i need that
Thank you!!
Hi Alex, you've such a great way to explain processes. Thank you for the content. Greetings from Brazil
So glad to hear that! Thanks for watching!
Please make Python Tutorial video for data analyst
That'll be the next series after the Power BI Series :)
Im stuck at 11:20. When I run pd.json_normalize(data['status']) it just says "name 'data' is not defined"
awesome
favori keltoşum
Hey Alex,
Firs off, I love your videos! second, I am having a issue. Once I updated the data rate limit, it worked briefly and then my ipykernel could not reconnect. did anyone else have this problem or know how to fix it?
Can we retrieve data from other web site using this code?
How to write a code that keeps capturing the numbers as they change? With the date of change
Cool
I know this is old, but I'm getting a "Missing api key", even tho I used the same code as the doc, video, and tried different versions. When I test it in postman, it works fine.
create new api key it's free
Someone please help how he increased the data limit, what he mentioned in Anaconda prompt?
What would be a learning pathway to get from zero to understanding this?
I would probably take "Python for Everyone" on Coursera. It is fantastic to learn from basics all the way up to stuff like this.
Dude I work with anaconda environment and doing that or deploying something is impossible. I think it is because I don't have Python installed on my PC, as I said I use Anaconda, and I installed Python in there.
while running the below code, I'm getting a message saying Key error: data
pd.json_normalize(data['data'])
Would be helpful if someone could point out the solution for this
when you fetch data from api did u got the first 2 keys it should be status and data
Im having this same issue, did you figure it out?
Next power bi video ???
You’re too generous
I'm a Mac user, and there is no anaconda prompt, I don't know how to do...
did you find out?
@@nuraiymsardarbekova6509 I had the same issue! I used this guys tutorial th-cam.com/video/B_YlLf6fa5A/w-d-xo.html&ab_channel=emaadmanzoor its for windows but worked for me on mac. you need to access the hidden folder for jupyter (command + shift + . ) when looking in the root folder. then in the jupyter notebook config file you change the data limit and un comment out the code.
@@nuraiymsardarbekova6509 did you find out lol
@@nuraiymsardarbekova6509 I figured it out. Close you jupyter notebook and the jupyter bash terminal. Open a new terminal window (not a jupyter terminal just mac terminal) and copy and paste alexes command in there. It will open jupyter notebooks with the new settings and it will work.
Forth view
2024_08_26, Current tutorial works, with some error which needs fixing: IOPub data rate exceeded.
Need help please feel free to drop me a text
Thanks! You absolutely butchered that metaphor