JSON

Python provides a host of different methods to work with this common data storage formatPhoto by Shubham Dhage on UnsplashIf you work in tech — especially as a software engineer or data scientist — you’ve probably heard the term JSON thrown around fairly often. In fact, I’d bet that you’ve had to work with it yourself at one point or another.What is JSON Data?JSON stands for JavaScript Object Notation. Technically, it was derived from a subset of JavaScript focused on arrays and literals by a programmer named Douglas…

A set of useful pandas tools to successfully load and transform a JSON file(image by author using canva)Loading and doing Transformations over a JSON (JavaScript Object Notation) file is something pretty common in the Data Engineering/Science world.JSON is a widely used format for storing and exchanging data. For example, NoSQL database like MongoDB store the data in JSON format, and REST API’s responses are mostly available in JSON.Although JSON works great for exchanging data over a network, if we intend to process the…

Learn a standard way to ensure your data qualityImage by kreatikar in PixabayA JSON document can contain any number of key/value pairs. The key must be a string but the value can be any supported type, such as string, number, boolean, etc. The value can even be complex types like an array or nested object. This makes the JSON document both very flexible and very unstructured. However, this makes data processing more difficult because the data team often gets data through APIs whose responses are normally in JSON format.…

Introducing the File Format used for Data-InterchangePhoto by Ferenc Almasi on UnsplashJSON is the abbreviation for the Java Script Object Notation file format. It describes a standardized data format for storing data. It is one of the text file formats because the data is stored in human-readable, natural language.The structure of JSON files is, simply put, an unordered collection of key-value pairs. For Python programmers, this structure is best compared to the Python Dictionary.# JavaScript Object Notation { "city":…

Learn basic JSON operations with simple examplesImage by kreatikar in PixabayJSON (JavaScript Object Notation) is a text format that is language-independent and is commonly used to interchange data between different applications. A good example is that the responses from APIs are normally in JSON format, therefore the backend and frontend can interchange data freely with no need to know the technical details of each other. In this post, we will introduce the common use cases of JSON in Python, a popular language for…

Recursively search JSON API responses to accelerate your productivityCredit: Pexels.comFor data scientists, the temptation is real to bypass computer science fundamentals and software engineering best practices in pursuit of tool mastery (Pandas & SKLearn to name two) and start adding value to your organization immediately.Many fundamental concepts in CS really are worth the hassle as they’ll enable you built concise, scalable logic when tediously wrangling unwieldy data. Throughout this post, we’ll work our way up to…