02:08 JSON and SQL are widely used data formats in programming 04:16 Learn how to work with JSON and SQL in Python 06:24 The tutorial explains how to read and convert JSON data into a pandas dataframe. 08:32 Converting a SQL file into a pandas dataframe 10:40 Start Apache and MySQL servers and import a dataset into a new database 12:48 Create a connection to a MySQL database in Python using MySQL.Connector 14:56 The function read_SQL_query in Pandas can create a dataframe by executing a SQL query with a connection object. 17:00 Life expectancy is greater than 60 in 167 countries.
I got stuck while setting connection to the mysql database. InterfaceError: 2003: Can't connect to MySQL server on 'localhost:3306' (111 Connection refused) can someone please help me?
@CampusX This playlist is ML playlist or Data science playlist. Because, till now the concepts covered seems to be of data science; but you have named this playlist as ML. And you have another playlist named Data Science.
02:08 JSON and SQL are widely used data formats in programming
04:16 Learn how to work with JSON and SQL in Python
06:24 The tutorial explains how to read and convert JSON data into a pandas dataframe.
08:32 Converting a SQL file into a pandas dataframe
10:40 Start Apache and MySQL servers and import a dataset into a new database
12:48 Create a connection to a MySQL database in Python using MySQL.Connector
14:56 The function read_SQL_query in Pandas can create a dataframe by executing a SQL query with a connection object.
17:00 Life expectancy is greater than 60 in 167 countries.
Thanks!, this PlayList is super helpful. Keep up the good work, Nitish!
Glad you liked it
Loving the course♥
Really it's very helpful i will also give gurudakshina
I have never commented on any UA-cam video. This video , the whole playlist made me. Salute to your efforts SIR!!!!!!!... I am forever in your debt
Usually I do not prefer comments on UA-cam but I respect your afferts. Thank for every thing
You are the only youtuber , who is interpreting all the subparameters thanxxx
its called real content... thank you sir ji
Really you are awesome teacher 👍😊
00:33 working with JSON
06:56 working with SQL
Course Started : ML
Lecture-01: 14/08/2024
Lecture-02: 14/08/2024
Lecture-03: 14/08/2024
Lecture-04: 14/08/2024
Lecture-05: 14/08/2024
Lecture-06: 15/08/2024
Lecture-07: 15/08/2024
Lecture-08: 15/08/2024
Lecture-09: 15/08/2024
Lecture-10: 15/08/2024
Lecture-11: 16/08/2024
Lecture-12: 16/08/2024
Lecture-13: 17/08/2024
Lecture-14: 17/08/2024
Lecture-15: 18/08/2024
Lecture-16: 19/08/2024
i wish i watched ur videos 2years ago 😄..Good Work bro..thanks
Informative I like your way of teaching
Good Content.
Thanks Nitesh😀
Thanks dear for this playlist ❤❤❤
Pretty much amazing playlist in entire youtude. I loved it
My fvrt mentor. 😍😍😍
Awesome 👍🙏✌️❤️
finished watching
THANKYOU!
Can we do the sql thing with mysql workbench too?
Do we need to keep our server running while making a connection to the mysql database
Most important video thank you….
Very much helpful if video is in English (for non hindi)
is there any need to learn c++ or java for data scientist role in big MNCs?
Not really
@@campusx-official sir what's your wp no ?
Thank you very much sir
My machine is giving error like 111 connection refuse
Can anybody explain me
Jp Here,
Thank you sir :)
Fabulous 🤩
thank you sir for showing, how to extract data from the database. Sir pymysql library will also work instead of MySQL.connector
Thanks sir
how can we convert the json file to csv perfectly?
Thanks
Kudos for you
Done thanks for the video
Thank u very much Sir for this video...apny nalaik dosto se share krna to bnta he ye 😂😂
I got stuck while setting connection to the mysql database.
InterfaceError: 2003: Can't connect to MySQL server on 'localhost:3306' (111 Connection refused)
can someone please help me?
Hello sir this video very very important for beginers i want to you please make a project sql and jupter notebook using complete project
@CampusX This playlist is ML playlist or Data science playlist. Because, till now the concepts covered seems to be of data science; but you have named this playlist as ML. And you have another playlist named Data Science.
Can we do this using SSMS? will XAMPP be needed then?
Json is javascript object notations ,
JSON stands for JavaScript Object Notation. RIGHT SIR THANKS FOR CORRECTION.
completed hufff🕶
What is need of xampp?
Anyone please
2003: Can't connect to MySQL server on 'localhost:3306' (111 Connection refused) anyone pls help
ValueError: Unexpected character found when decoding array value (2)
when i'm trying to read json file
I CANT EXPLAIN HOW VALUABLE THIS INFO IS...UNDERVIEWS STILL...
ProgrammingError: 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
same have you solved it?
same problem
done
Done
I WISH I WATCHED BEFORE MY INTERVIEW, NOW I AM NOT GOING TO SKIP A SINGLE DAY AND WILL COMPLETE ALL REMAINING IN DAYSSSSSSSSS :(( COMPLETED 15