Hello there and thanks for the great content. As you are already using ipython (within Jupyter Notebook), I can recommend the %timeit command which automatically chooses an appriorate number of iterations based on the first run and then will loop that number of times over your piece of code and return the mean value and the standard deviation. This reduces "fluctuations" or "noise" in your measurement due to other load your OS is dealing with sometimes. If you have loops in the millions and above and you are working on improvements in micro- and nano-seconds scales, %timeit becomes an essential and comfortable tool. For multiple lines of code, just pack them in a function quickly and %timeit yourfunction(args)
I am happy with your explanation about python. đ Previously I have used php with codeigniter 4 framework and oracle database. how to migrate all my code to python? Thanks for your time.đ
Awesome, I would start by weighing up the pros and cons of moving a codebase from one language and set of tools to another. A couple of python packages to look into would be Django and Flask for a full featured web development. I would also checkout packages like fastAPI you wanted to split out fronend and backend and serve up data from Oracle via an API endpoint. Oracle recently released a new Python driver which might be worthwhile having a play with python-oracledb. Happy researching and let me know how you go!
I dont know how to start, i have alot of file and thousand line of my code. Im solo programmer and still beginner. Maybe this will be my challenge to research more about python. đ
Howdy Adam. Would you use comments in your Jupyter notebook as you comments are useful in code regardless of any programming language, hope you agree with me đ As always many thanks for useful videos and tutorials. Br Syed
Howdy. Great video đ. Can you tell us from where this Database came from? Is it available for the public to play with? I am guessing you copied the Database locally to your laptop? Many thanks
Of course I can, as part of my upcoming web scraping video I obtained registered charity listings in Australia from this resource acnc.gov.au/ and in that video I will be going over how to best save JSON payloads into SQLite3 in Python for easy analysis!
@@MakeDataUseful Maybe you should of released the web scraping to SQLite3 before this one. I want to follow along but dont know how I should be formatting the table/database lol. I dont suppose you have an ETA of the next video?
Hello there and thanks for the great content. As you are already using ipython (within Jupyter Notebook), I can recommend the %timeit command which automatically chooses an appriorate number of iterations based on the first run and then will loop that number of times over your piece of code and return the mean value and the standard deviation. This reduces "fluctuations" or "noise" in your measurement due to other load your OS is dealing with sometimes. If you have loops in the millions and above and you are working on improvements in micro- and nano-seconds scales, %timeit becomes an essential and comfortable tool. For multiple lines of code, just pack them in a function quickly and %timeit yourfunction(args)
Love it! Iâm going give %timeit another go!
Impressive result of speed up of a SqLite-call! Great!
Keep up the good work, I love your content and character.
Hi Adam, Great content!! thank you! Keep it up!!
When are you releasing the Webscraping Tutorial? I would like to know, what is the best way to insert JSON Data into a SQLite3 DB.
Soon! Itâs going to be a good one!! đ€
It's getting difficult to sip that coffee at this speed.
I got a little excited in this one!
I am happy with your explanation about python. đ
Previously I have used php with codeigniter 4 framework and oracle database. how to migrate all my code to python?
Thanks for your time.đ
Awesome, I would start by weighing up the pros and cons of moving a codebase from one language and set of tools to another. A couple of python packages to look into would be Django and Flask for a full featured web development. I would also checkout packages like fastAPI you wanted to split out fronend and backend and serve up data from Oracle via an API endpoint. Oracle recently released a new Python driver which might be worthwhile having a play with python-oracledb. Happy researching and let me know how you go!
I dont know how to start, i have alot of file and thousand line of my code. Im solo programmer and still beginner. Maybe this will be my challenge to research more about python. đ
Howdy Adam.
Would you use comments in your Jupyter notebook as you comments are useful in code regardless of any programming language, hope you agree with me đ
As always many thanks for useful videos and tutorials.
Br
Syed
Howdy.
Great video đ.
Can you tell us from where this Database came from?
Is it available for the public to play with?
I am guessing you copied the Database locally to your laptop?
Many thanks
Of course I can, as part of my upcoming web scraping video I obtained registered charity listings in Australia from this resource acnc.gov.au/ and in that video I will be going over how to best save JSON payloads into SQLite3 in Python for easy analysis!
@@MakeDataUseful Maybe you should of released the web scraping to SQLite3 before this one. I want to follow along but dont know how I should be formatting the table/database lol. I dont suppose you have an ETA of the next video?