Entries by sciencegeek_admin

How to rewrite your SQL queries in Python with Pandas

Some of us are familiar with data manipulation in SQL but not in Python, we tend to switch frequently between SQL and Python in a project, result in reducing our efficiency and productivity. In fact, we can achieve a similar result of SQL in Python using Pandas. https://towardsdatascience.com/how-to-rewrite-your-sql-queries-in-python-with-pandas-8d5b01ab8e31

How to Build a Personal Dev Server on a $5 Raspberry Pi

In this article, you’ll learn how to build a personal dev server by installing Git, Node.js, Rust, and Docker on a Raspberry Pi. The cheapest option costs just $5. Learn how you can get a starter kit ($25) for free here. The Raspberry Pi is a very powerful computer in a tiny package. https://www.freecodecamp.org/news/build-a-personal-dev-server-on-a-5-dollar-raspberry-pi/

Remote humidity detector

You need to keep an eye on the humidity level in your crawl space, as it can seriously affect the whole house’s overall health. It’s ideal to be able to do this remotely (given the creepy, sweaty atmosphere of the space), and a Raspberry Pi allows this. https://www.raspberrypi.org/blog/remote-humidity-detector/

Get started with Power BI Desktop

Welcome to the getting started guide for Power BI Desktop. This tour shows you how Power BI Desktop works, what it can do, and how to build robust data models and amazing reports to amplify your business intelligence. https://docs.microsoft.com/en-us/power-bi/fundamentals/desktop-getting-started

Autoviz: Automatically Visualize any Dataset

Visualization is a technique that is used to visualize the data using different graphs and plots. In data science, we generally use data visualization techniques to understand the dataset and find the relation between the data. https://towardsdatascience.com/autoviz-automatically-visualize-any-dataset-ba2691a8b55a

10 Hidden URLs To Help You Rule The Web

You’re probably used to bookmarking your favourite sites for easy access, but the web goes much deeper than the top domains you’re familiar with—from your social networks to your email box, having the right URL to hand can enable you to jump right into the page, feature, setting, or search you https://www.gizmodo.com.au/2020/07/10-hidden-urls-to-help-you-rule-the-web/