TL, DR MongoDB is one of the leading NoSQL databases, and its aggregation framework enables powerful queries, as well as data operations. We will see how to save results from aggregation pipelines into a Pandas DataFrame. From MongoDB to Pandas I already provided an introduction to MongoDB and Compass in a previous post for my… Continue reading MongoDB aggregation: save results in a Pandas DataFrame
Tag: Tools
MongoDB aggregation: match a field with values in a list
TL, DR MongoDB is one of the leading NoSQL databases, and its aggregation framework enables powerful queries, as well as data operations. We will see how to match a field with values in a list to help you select. Matching values in a list I already provided an introduction to MongoDB and Compass in a… Continue reading MongoDB aggregation: match a field with values in a list
MongoDB aggregation: create your data pipelines
TL, DR MongoDB is one of the leading NoSQL databases, and its aggregation framework enables powerful queries, as well as data operations. We will see how to quickly create data pipelines and create code you can use in your projects. The power of a Compass You use MongoDB as data repository because it’s so simple… Continue reading MongoDB aggregation: create your data pipelines
Fetch and display an image with PyScript
TL, DR PyScript is a new and cool piece of technology that let you use Python in the browser. In this tutorial we will create a webpage that fetch and display a cat image. More tutorials on PyScript to come! Use PyScript to fetch and display an image Python is famous for running everywhere. Jupyter… Continue reading Fetch and display an image with PyScript
Pandas: Convert list to dummies
TL, DR Sometimes you may have a list in a Pandas DataFrame column and you are looking to get individual dummy columns for further elaborations. Here a very short guide about how to convert a list to individual dummies. From list to dummies In many cases during data exploration and wrangling you will find that… Continue reading Pandas: Convert list to dummies
Scrapy: Select elements containing a specific text
TL, DR Scrapy is one of the top frameworks for web scraping in Python. Often you need to select some element where you already know part of its text. This post shows you how to select elements containing a certain text with CSS and XPATH selectors. How to select elements containing a certain text in… Continue reading Scrapy: Select elements containing a specific text
Call an API from PyScript
TL, DR PyScript is a new and cool piece of technology that let you use Python in the browser. In this tutorial we will call an API from PyScript and display the result on our webpage. More tutorials on PyScript to come! How to make HTTP requests from PyScript to an external API? PyScript, a… Continue reading Call an API from PyScript
PyScript REPL in a webpage
TL, DR PyScript is a new and cool piece of technology that let you use Python in the browser. In this tutorial we will embed a PyScript REPL in a webpage. More tutorials on PyScript to come! Embed a PyScript REPL in a webpage Python is famous for running everywhere. Jupyter Notebooks enabled professionals and… Continue reading PyScript REPL in a webpage
Export a Pandas DataFrame to HTML table
TL, DR If you ever tried to write a big table in HTML from scratch, you know how much it can be tedious. Fortunately, there are ways to convert data from a Pandas DataFrame to a HTML table with a simple call. Making tables in HTML from Pandas DataFrames HTML is the standard language of… Continue reading Export a Pandas DataFrame to HTML table
Create a Latex table from a CSV files
TL, DR If you ever tried to write a big table in Latex from scratch, you know how much it can be tedious. I wrote a small application leveraging Python Pandas and PySimpleGUI to create a Latex tables from any CSV file. Making tables in Latex from CSV files In a previous post I already… Continue reading Create a Latex table from a CSV files
