Best of Data ScienceFebruary 2024

  1. 1
    Article
    Avatar of gcgitconnected·2y

    🐼 Mastering SQL Joins

    This post explores the concept of table joins in SQL, covering different join types such as inner join, left join, and right join. It also discusses how to identify and handle orphan records in a database.

  2. 2
    Article
    Avatar of kdnuggetsKDnuggets·2y

    7 Free Harvard University Courses to Advance Your Skills

    Get started on your tech career with free courses from Harvard University. Learn computer science, artificial intelligence, data science, web programming, game development, and cybersecurity.

  3. 3
    Article
    Avatar of towardsdevTowards 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.

  4. 4
    Article
    Avatar of hnHacker News·2y

    Your Phone Isn’t Spying on You to Show You Ads (It’s Worse Than That)

    Your phone is not listening to you to show you ads, but it is collecting data such as location information, search history, browsing history, purchase history, and physical interactions. Advertisers use this data to target ads based on your interests and the people you spend time with. While targeted advertising can seem accurate and sometimes mysterious, it is based on algorithms and large datasets. The next step in advertising is generative AI, which could create personalized ads that target your insecurities and dreams. However, there are tools available to help protect your privacy online, such as Apple's App Tracking Transparency feature and privacy controls on operating systems and browsers.

  5. 5
    Article
    Avatar of substackSubstack·2y

    What are Semi, Anti, and Natural Joins in SQL?

    This post introduces three types of joins in SQL: semi join, anti join, and natural join. It explains the differences between these joins and their use cases. The post also provides examples and visual summaries of each join.

  6. 6
    Article
    Avatar of taroTaro·2y

    The Fundamentals of Data Engineering - Preface + Chapter 1: Data Engineering Described

    This post provides an overview of the book 'Fundamentals of Data Engineering', discussing the motivations behind the book and the importance of data engineering in relation to data science and machine learning. It covers the Data Science Hierarchy of Needs, the Data Engineering Lifecycle, and the skills and activities of a Data Engineer. The post also discusses the stages of Data Maturity and the different types of Data Engineers. The next blog post will cover Chapter 2 of the book.

  7. 7
    Article
    Avatar of itnextITNEXT·2y

    Data structure for file management application

    This post explores the limitations of standard data structures and delves into the advantages of using a red-black tree and a B-tree. It highlights the efficiency of B-trees for managing large data sets and real-time applications.

  8. 8
    Article
    Avatar of freecodecampfreeCodeCamp·2y

    Learn Python Basics – A Guide for Beginners

    Learn Python Basics - A Guide for Beginners

  9. 9
    Article
    Avatar of medium_jsMedium·2y

    Setting A Dockerized Python Environment — The Hard Way

    This post reviews different methods to run a dockerized Python environment from the command line (CLI). It explains how to customize a built-in image using a Dockerfile and mount a local folder to the container for code maintenance.

  10. 10
    Article
    Avatar of hrbHEARTBEAT·2y

    Web Scraping With 5 Different Methods: All You Need to Know

    Learn about web scraping techniques using various methods like BeautifulSoup, Requests, Scrapy, and Selenium. Also explore the use of LangChain for web scraping.

  11. 11
    Article
    Avatar of kdnuggetsKDnuggets·2y

    Free Data Analyst Bootcamp for Beginners

    Learn data analytics skills and build a project portfolio with the free Data Analyst Bootcamp for Beginners. The bootcamp covers SQL, Excel, Tableau, Power BI, Python, and more.

  12. 12
    Video
    Avatar of fireshipFireship·2y

    how god programmed birds probably

    Birds fly together in unison using an algorithm built into nature, which can be reproduced in computers using three simple rules. These rules include separation, alignment, and cohesion, and they create cool patterns that simulate flocking behavior in nature.

  13. 13
    Article
    Avatar of medium_jsMedium·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.

  14. 14
    Article
    Avatar of kdnuggetsKDnuggets·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.

  15. 15
    Article
    Avatar of kdnuggetsKDnuggets·2y

    Collection of Free Courses to Learn Data Science, Data Engineering, Machine Learning, MLOps, and LLMOps

    A collection of free courses for learning data science, data engineering, machine learning, MLOps, and LLMOps is provided. The courses are self-paced and community-based, offering valuable resources for beginners and experienced professionals.

  16. 16
    Article
    Avatar of kdnuggetsKDnuggets·2y

    7 Free Kaggle Micro-Courses for Data Science Beginners

    Learn essential data science skills with free micro-courses on Kaggle. Courses cover Python basics, pandas, data visualization, SQL, machine learning, and more. Start your data science journey one micro-course at a time.

  17. 17
    Article
    Avatar of medium_jsMedium·2y

    I am Aurora, the Most Powerful AI Financial Assistant That The World Has Ever Seen

    Aurora is a powerful AI financial assistant developed by Austin Starks. Aurora specializes in trading automation and financial research, aiming to make investing and trading more accessible. Aurora can generate tailored indicators, design trading strategies, and analyze company financial information. Austin believes that Aurora's ability to find novel investing opportunities using natural language makes it more powerful than any other platform. Aurora is a neural network powered by OpenAI's GPT APIs and plans to improve its functionality in 2024.

  18. 18
    Article
    Avatar of rpythonReal Python·2y

    Create Conway's Game of Life With Python – Real Python

    Learn how to implement Conway's Game of Life algorithm in Python, create a 'curses' view for displaying the grid, and set up a Python project for installation and execution.

  19. 19
    Article
    Avatar of freecodecampfreeCodeCamp·2y

    How to Download a Kaggle Dataset Directly to a Google Colab Notebook

    Learn how to download a Kaggle dataset directly to a Google Colab notebook. Explore the types of Kaggle datasets and the prerequisites for the process.

  20. 20
    Article
    Avatar of medium_jsMedium·2y

    5 Free Data Visualization Tools to Showcase Your Data in 2024

    Discover five free data visualization tools that can showcase your data in 2024, including Tableau Public, Google Looker Studio, Microsoft Power BI, HiPlot, and Facets by PAIR.

  21. 21
    Article
    Avatar of medium_jsMedium·2y

    How to Find the Best Stocks in the Stock Market Using AI

    Learn how to use AI to find the best stocks in the stock market using the NexusTrade Platform. Discover the features of intelligent stock screening and the implementation process. Also, explore the MongoDB Aggregation Framework for executing complex queries.

  22. 22
    Article
    Avatar of awstipAWS Tip·2y

    Django vs Streamlit Frameworks for Implementing Machine Learning Models

    Comparison of Django and Streamlit frameworks for implementing machine learning models. Django simplifies and accelerates web development, while Streamlit is used to build interactive user interfaces for data science applications. Django allows for more flexible front-end development, but Streamlit is easier to implement. Django is recommended for more complex projects, while Streamlit is recommended for beginners or testing models.

  23. 23
    Article
    Avatar of kdnuggetsKDnuggets·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.

  24. 24
    Article
    Avatar of medium_jsMedium·2y

    Stock Market Sentiment Prediction with OpenAI and Python

    This article explores the use of OpenAI and Python for predicting stock market sentiment. It discusses the importance of sentiment analysis in making strategic decisions and introduces the Stock Market and Financial News API. The article provides step-by-step instructions on importing packages, activating the API key, extracting and cleaning the data, setting up the LLM chain, and visualizing the sentiment analysis results. The analysis reveals a prevailing optimistic sentiment towards Apple Inc. in recent news articles.