DATA SCIENCE SKILLS: Gentle Introduction to sqlite3. Python, SQLite and Databases
HTML-код
- Опубликовано: 11 сен 2024
- Sponsored by Dataquest. Dataquest offers courses that help you learn Data Science 100% online: www.dataquest....
You can create your FREE account and get started with any of their 60+ free lessons to sharpen your data skills
Tutorial starts at 02:14
SQLite & Pandas 12:30
How to use python, SQLite and sqlite3. Python makes handling databases straightforward.
Skill Paths Page www.dataquest....
SQL Fundamentals Page www.dataquest....
WANT TO LEARN PYTHON? Try my courses:
bit.ly/2JuehGa
How to Learn Data Science for Free. My RUclips video:
• Everything you need to...
My favourite books (affiliate link) www.amazon.co....
/ gilesmcmullen
/ gilesmcmullen
👌 SUBSCRIBE to ME!👌
/ @gilesmcmullen
Yours is a highly underrated channel amongst the computer science related channels on RUclips. Great video as always. ❤
It's spooky how timely some of your videos are. After sitting on an online Python course for a year, I have only this weekend started with the SQLite section. Happy to see the practices reinforced here with some great features I was wondering about (using with Pandas), but hadn't learned yet. Thank you for all of your content.
Perfect timing for this video. Started looking at sqlite last week, then deceided it was to advanced for me, and just wanted to save my data as json/dict/csv file.. A buddy of mine convinced me to go back to sql, so will try that, and with your video i just got a good introduction to it. :)
You don't have to delete the database. You already added the condition: CREATE TABLE IF NOT EXISTS books - this ensures that the books table is created only when it doesn't already exists.
Thank you so much, just what I was looking for, very well designed - cheers!
Thank You! ❤️❤️
Amazing Video, been waiting for this.
this is exactly what I was lookiing for. Thank you Python Programmer !
Thankyou sir❤️
Love Sqllite and sqllite studio is a massive time saver.
A gentle introduction by an English gentleman.
Some of the code is cropped off on the right hand side. Is it available as a download?
Thank you ,so informative video :).
My favorite SQLite command.
.mode csv
I'll always wanted this videos to be in OOP style
Make a video on Machine Learning using WSL2 platform. (On Windows 10)
A comb. of Python and sqlite3 offers the modern environment for interactive data management
Always the best
Thanks for lesson maestro!
Hi, what about relations? If I have two tables. In first Books(id, title, authorId, price), the second Authors(authorId, firstName, secondName). Do I need to use JOIN in SQL command or is there a more pythonic way?
14:29 - 'DataFrame' object has no attribute 'append'
S tier vid
Could you highlight some real world use cases for this? If I understand correctly, this can't be used to create a persistent database. For example load data walk away come back next week and the dad is still there. If you can't do that? What's the use of this? Thanks much
I've never watched a single one of this guy's videos before, but on seeing the link and his attire, I thought to myself, "this man is going to have a British accent." Why did that thought run through my mind? Why was it accurate? I have no idea. Is there really anything about his attire that screams "I'm British"? Not that I can see. Such strange coincidences we sometimes experience.
Pretty cool
Hey -
what colour theme are you using for vccode?
The only question that i dont understand is how to insert to many data in such ways.. It is not comfy to enter massive data with command like that
Hi
I miss some of your videos because i did not recognize it is yours
will be better if you put your photo in video thumbnail to recognize it
Sqlite doesn’t come with Python. The module does.
.
Hey -
what colour theme are you using for vccode?
Hey -
what colour theme are you using for vccode?