100 Days of Machine Learning | CampusX - Working with JSON/SQL | Day 16 | 100 Days of Machine Learning

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: https://github.com/campusx-official/100-days-of-machine-learning/tree/main/day16%20-%20working-with-json-and-sql Xampp download link: https://www.apachefriends.org/index.html World dataset : https://www.kaggle.com/busielmorley/worldcities-pop-lang-rank-sql-create-tbls?select=world.sql Pandas read_json documentation: https://pandas.pydata.org/docs/reference/api/pandas.read_json.html Pandas read_sql_query documentation: https://pandas.pydata.org/docs/reference/api/pandas.read_sql_query.html#pandas.read_sql_query ============================ Do you want to learn from me? Check my affordable mentorship program at : https://learnwith.campusx.in/s/store ============================ 📱 Grow with us: CampusX' LinkedIn: https://www.linkedin.com/company/campusx-official CampusX on Instagram for daily tips: https://www.instagram.com/campusx.official My LinkedIn: https://www.linkedin.com/in/nitish-singh-03412789 Discord: https://discord.gg/PsWu8R87Z8 Instagram: https://www.instagram.com/campusx.official E-mail us at [email protected]