Skip to content


Latest articles on LLM, AGI, Open Source, Infrastructure, and more.

Easy Steps: How to Change Date Format in Google Sheets

Learn how to change date formats in Google Sheets with step-by-step instructions. Convert text to date, change to European style, and more.

5 Ways to Format Cells in Google Sheets

Mastering Google Sheets Cell Formatting: 5 Tips for Custom Conditional Formatting, Text Formatting, and More! A comprehensive guide to formatting cells in Google Sheets with easy-to-follow tips and tricks.

[Explained] How to Use SUMIF and COUNTIF in Google Sheets

Boost your Google Sheets expertise by mastering SUMIF and COUNTIF functions. Learn the syntax, explore real-life examples, and leverage wildcard techniques for advanced data analysis and summary tasks.

How to Effortlessly Create a Pivot Table in Pandas

Learn how to create a Pivot Table in Pandas with our easy-to-follow guide. We'll cover everything you need to know, including how to set up your data and customize your Pivot Table. Also, we'll use PyGWalker to turn Pandas Dataframes into beautiful charts!

How to Easily Merge, Join and Concat Pandas DataFrames

Learn how to merge Pandas DataFrames in Python with our step-by-step guide. We'll cover everything you need to know, from inner and outer joins to merging on specific columns, together with creating data visualization from pandas dataframes with PyGWalker.

ChatGPT Prompts for Pandas Data Visualization

Learn how to turn your pandas dataframes into beautiful charts with ChatGPT prompts and PyGWalker, and how to explain your ML models with LIME and Shap.

How to Read CSV Files in Pandas - Essential Guide for Beginners

Learn how to read CSV files in Pandas, including skipping columns/rows, selecting columns, and setting data types, with PyGWalker as a bonus tool for data visualization.

How to Use ChatGPT to Enhance Data Analysis Workflow

Discover the benefits of ChatGPT data analysis and how it can improve your productivity. Read our comprehensive guide now.

SQL Cheat Sheet - 9 Must-Known SQL Syntax for Beginners

Learn 9 crucial SQL syntax tips for beginners and discover the RATH alternative for data analysis and visualization. Boost your database skills now!

Can ChatGPT Replace Data Analysts at SQL Queries?

Learn how ChatGPT, a large language model by OpenAI, can generate efficient SQL queries for data aggregation, filtering, and optimization.