DEV Community

#dataanalysis

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
pandas pct_change and cumsum: Percent Change and Running Totals

pandas pct_change and cumsum: Percent Change and Running Totals

Comments
13 min read
pandas merge: Left Join, Inner Join, and the One That Doubled the Revenue

pandas merge: Left Join, Inner Join, and the One That Doubled the Revenue

Comments
13 min read
pandas read_csv: Your First DataFrame, and What It Guessed

pandas read_csv: Your First DataFrame, and What It Guessed

Comments
14 min read
Handling Missing Values in pandas: dropna, fillna and What Each One Claims

Handling Missing Values in pandas: dropna, fillna and What Each One Claims

Comments
14 min read
pandas drop_duplicates: keep='first', and the Row It Chose For You

pandas drop_duplicates: keep='first', and the Row It Chose For You

Comments
13 min read
How to Install Python for Data Analysis (And Why pip install Then Fails)

How to Install Python for Data Analysis (And Why pip install Then Fails)

Comments
13 min read
How to Install Power BI Desktop (Including on a Locked-Down Work Laptop)

How to Install Power BI Desktop (Including on a Locked-Down Work Laptop)

Comments
11 min read
How to Set Up Jupyter Notebook (And Why Your Environment Is Missing From the Kernel List)

How to Set Up Jupyter Notebook (And Why Your Environment Is Missing From the Kernel List)

Comments
13 min read
Where to Find Free Datasets to Practice With (And How to Pick One)

Where to Find Free Datasets to Practice With (And How to Pick One)

Comments
13 min read
Excel Tables vs Ranges: What Ctrl+T Actually Changes

Excel Tables vs Ranges: What Ctrl+T Actually Changes

Comments
14 min read
INDEX MATCH vs VLOOKUP: The Lookup That Survives a New Column

INDEX MATCH vs VLOOKUP: The Lookup That Survives a New Column

Comments
17 min read
Excel Dynamic Arrays: FILTER, UNIQUE and SORT in One Formula

Excel Dynamic Arrays: FILTER, UNIQUE and SORT in One Formula

Comments
14 min read
Excel Drop Down Lists and Data Validation, and the Paste That Removes Them

Excel Drop Down Lists and Data Validation, and the Paste That Removes Them

Comments
14 min read
How to Connect Python to a SQL Database (Straight Into a DataFrame)

How to Connect Python to a SQL Database (Straight Into a DataFrame)

Comments
10 min read
How to Connect Excel to a SQL Database (And Stop Pasting)

How to Connect Excel to a SQL Database (And Stop Pasting)

Comments
12 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.