Best of Data Analysis — February 2024

1. 1
   Article

   Towards Dev·2y

   3 Essential SQL Tricks You Absolutely Need to Know

   Learn three essential SQL tricks that can improve efficiency and analytical capabilities. Topics include using Common Table Expressions (CTEs), creating Partial Indexes for faster searches, and implementing Conditional Aggregation in SQL queries.

   172

   9
2. 2
   Article

   freeCodeCamp·2y

   JavaScript Map Method – Syntax and Code Examples

   Explore the syntax and applications of the JavaScript map method, a versatile tool for array manipulation and transformation. Learn how to use it for data and object transformation, string manipulation, and working with the index.

   37

   3
3. 3
   Article

   freeCodeCamp·2y

   How to Build a Job Board Scraper with Python

   Learn how to build a job board scraper with Python using the Pyppeteer framework. This tutorial covers the basics of web scraping and provides step-by-step instructions for extracting job listings from websites like Indeed.com. You'll also learn how to store the scraped data and clean and organize it for analysis.

   31
4. 4
   Article

   Medium·2y

   Building an Investment Portfolio Management App with Python

   Learn how to build an investment portfolio management app with Python and Streamlit. The app helps track investment performance, analyze portfolio allocation, and evaluate the historical performance of individual securities. It provides interactive visualizations and insights to guide decision-making.

   19
5. 5
   Article

   KDnuggets·2y

   7 Steps to Mastering Exploratory Data Analysis

   Learn the basic steps of Exploratory Data Analysis (EDA) and how it can enhance the clarity and understanding of datasets.

   19
6. 6
   Article

   KDnuggets·2y

   Master The Art Of Command Line With This GitHub Repository

   Learn the art of command line with a popular GitHub repository that provides essential command-line knowledge, covering basic commands, file and data processing, system debugging, and more. The guide is available in multiple languages and is perfect for beginners and experienced users alike.

   11
7. 7
   Article

   KDnuggets·2y

   Jupyter Notebook Magic Methods Cheat Sheet

   KDnuggets' cheat sheet provides a comprehensive reference to utilizing Jupyter Notebook magic methods effectively, improving coding practices in the notebook environment.

   11
8. 8
   Article

   KDnuggets·2y

   The Essential Guide to SQL’s Execution Order

   Discover the hidden logic behind SQL's execution order, understand the importance of knowing the execution order, and avoid common mistakes when using it.

   10