Це відео не доступне.
Перепрошуємо.
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
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
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
You are the only youtuber , who is interpreting all the subparameters thanxxx
its called real content... thank you sir ji
Pretty much amazing playlist in entire youtude. I loved it
Informative I like your way of teaching
Really you are awesome teacher 👍😊
Thanks dear for this playlist ❤❤❤
i wish i watched ur videos 2years ago 😄..Good Work bro..thanks
Most important video thank you….
Good Content.
Thanks Nitesh😀
Awesome 👍🙏✌️❤️
thank you sir for showing, how to extract data from the database. Sir pymysql library will also work instead of MySQL.connector
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.
Fabulous 🤩
Kudos for you
Thanks sir
Thank you very much sir
Done thanks for the video
Do we need to keep our server running while making a connection to the mysql database
Thanks
My fvrt mentor. 😍😍😍
finished watching
Can we do this using SSMS? will XAMPP be needed then?
Very much helpful if video is in English (for non hindi)
If someone coding in google colab then how did you read SQL data? Like how did you create the database for it, please help
Hello sir this video very very important for beginers i want to you please make a project sql and jupter notebook using complete project
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?
completed hufff🕶
@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
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 ?
done
00:33 working with JSON
06:56 working with SQL
What is need of xampp?
Anyone please
Thank u very much Sir for this video...apny nalaik dosto se share krna to bnta he ye 😂😂
Json is javascript object notations ,
JSON stands for JavaScript Object Notation. RIGHT SIR THANKS FOR CORRECTION.
I CANT EXPLAIN HOW VALUABLE THIS INFO IS...UNDERVIEWS STILL...
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
ProgrammingError: 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
same have you solved it?
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