TL, DR MongoDB is one of the leading NoSQL databases, and Compass is its desktop GUI. We will see how we can leverage it to create new users. Creating users from Compass I already provided an introduction to MongoDB and Compass in a previous post for my MongoDB series. In this post we will explore… Continue reading Create a MongoDB user from Compass
Month: July 2025
Drop Pandas DataFrame columns only if they exist
TL, DR Sometimes you need to drop columns in a Pandas DataFrame, but you may not be sure they actually exist. Here a few snippets to do it without raising errors. Safely Dropping Columns That Might Not Exist Sometimes, your dataset might include placeholder or optional columns such as “Unknown”, “Other”, or “None”. You may… Continue reading Drop Pandas DataFrame columns only if they exist
Calculate metrics on numeric columns only for Pandas DataFrames
TL, DR Sometimes you need to calculate averages, minimums, or other metrics from numeric-only columns in a Pandas DataFrame. Here a few snippets to do it. Select numeric columns and calculate metrics You often want to calculate summary statistics like the mean , median , or standard deviation — but you only care about numeric… Continue reading Calculate metrics on numeric columns only for Pandas DataFrames
Use rsdmx to access data
TL, DR rsdmx is a great R package to access data via SDMX. Sometimes the configuration of parameters to access the data may not be intuitive. Here a quick note from few hours spent trying to access data from ISTAT. Install and import rsdmx This is easily achieved opening R or Rstudio and calling: For… Continue reading Use rsdmx to access data