Working with JSON/SQL | Day 16 | 100 Days of Machine Learning
ฝัง
- เผยแพร่เมื่อ 30 มี.ค. 2021
- JavaScript Object Notation (JSON) is a standard text-based format for representing structured data based on JavaScript object syntax. JSON is a lightweight data format used for data interchange between multiple different languages. It is easy to read for humans and easily parsed by machines. It's pretty common for websites to return JSON from API's so that the information is easy to parse by different programming languages.
SQL(Structured Query Language) is used to manage relational databases, and It is used to perform fetching rows, database creation, modifying databases, deleting databases, and also reading, writing data. It is extremely useful in managing structured data, i.e. data that is used to represent relations among entities and variables. SQL is predicated on relational algebra and tuple relational calculus. MS Access, MySQL is a standard database language.
Working with JSON/SQL involves handling structured data in JSON format or querying relational databases using SQL, essential skills for data manipulation and analysis.
Code used: github.com/campusx-official/1...
Xampp download link: www.apachefriends.org/index.html
World dataset : www.kaggle.com/busielmorley/w...
Pandas read_json documentation: pandas.pydata.org/docs/refere...
Pandas read_sql_query documentation: pandas.pydata.org/docs/refere...
============================
Do you want to learn from me?
Check my affordable mentorship program at : learnwith.campusx.in/s/store
============================
📱 Grow with us:
CampusX' LinkedIn: / campusx-official
CampusX on Instagram for daily tips: / campusx.official
My LinkedIn: / nitish-singh-03412789
Discord: / discord
Instagram: / campusx.official
E-mail us at support@campusx.in
![[4K] BABYMONSTER(베이비몬스터) “FOREVER” Band LIVE Concert “영원히” 베몬만을 사랑하게 되…💗 [it’s KPOP LIVE 잇츠라이브]](http://i.ytimg.com/vi/TQfC0xdpiw4/mqdefault.jpg)
I have never commented on any TH-cam video. This video , the whole playlist made me. Salute to your efforts SIR!!!!!!!... I am forever in your debt
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
Usually I do not prefer comments on TH-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 👍😊
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.
Pretty much amazing playlist in entire youtude. I loved it
Informative I like your way of teaching
Thanks dear for this playlist ❤❤❤
Most important video thank you….
i wish i watched ur videos 2years ago 😄..Good Work bro..thanks
Good Content.
Thanks Nitesh😀
Thank you very much sir
Awesome 👍🙏✌️❤️
Thanks sir
Thanks
Fabulous 🤩
finished watching
My fvrt mentor. 😍😍😍
Done thanks for the video
Kudos for you
Very much helpful if video is in English (for non hindi)
thank you sir for showing, how to extract data from the database. Sir pymysql library will also work instead of MySQL.connector
Do we need to keep our server running while making a connection to the mysql database
Can we do this using SSMS? will XAMPP be needed then?
Hello sir this video very very important for beginers i want to you please make a project sql and jupter notebook using complete project
If someone coding in google colab then how did you read SQL data? Like how did you create the database for it, please help
@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.
Done
00:33 working with JSON
06:56 working with SQL
completed hufff🕶
I CANT EXPLAIN HOW VALUABLE THIS INFO IS...UNDERVIEWS STILL...
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?
done
ValueError: Unexpected character found when decoding array value (2)
when i'm trying to read json file
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 ?
Json is javascript object notations ,
JSON stands for JavaScript Object Notation. RIGHT SIR THANKS FOR CORRECTION.
Thank u very much Sir for this video...apny nalaik dosto se share krna to bnta he ye 😂😂
What is need of xampp?
Anyone please
2003: Can't connect to MySQL server on 'localhost:3306' (111 Connection refused) anyone pls help
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
ProgrammingError: 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
same have you solved it?