Statistics

In statistics, a marginal distribution refers to the probability distribution of a variable irrespective of other variables. Marginal probability is obtained by adding (discrete case) or integrating (continuous case) the joint distribution over other variables. In economics, ‘marginal’ refers to the incremental change in a variable corresponding to a unit change in another variable. The calculation involves taking the derivative of the relevant function. Examples: marginal cost (change in total cost when one more unit of a good is produced), marginal product (change in the total production for one additional unit of input), marginal utility, marginal tax rate, etc. ...

This tutorial focuses on SQL usage for data analysis (rather than transaction processing). DuckDB is the engine primarily used, so some commands might not work with SQLite and vice versa. Commands largely drawn from https://www.dbvis.com/wp-content/uploads/2024/04/SQL-Cheat-Sheet.pdf Datasets Palmer Penguins, Chinook, Elevation of Indian Cities. The raw datasets are located in ~/Datasets/Raw. Set 1: Loading and Exporting Loading Data cd to the Raw datasets folder. run duckdb chinook.sqlite. this opens a duckdb command line with chinook loaded. run describe; or show; to see the tables and data types. Alternatively, ...

Needed Some SQL Ran into a minor hiccup while performing some exploratory data analysis. The type of my columns was wrong. This is the kind of thing I want fixed before Python, R, or Julia touch the dataset. This is the kind of thing that would be suited for SQL. I have used MySQL for a different task that involves frequent updating. DuckDB is more suited for static data analysis. That ended up driving the choice of DuckDB. The CLI outputs are excellent. There are integrations available for Python, R, and Julia. ...