35:null 36:["$","title",null,{"children":"Descriptive statistics: comparisons in JavaScript, Python, SQL, R, and Excel | a-k | Observable"}] 3c:T30c3,compareFunctions = [ { method: "mean", language: "JavaScript", function: "d3.mean", link: "https://github.com/d3/d3-array/blob/v3.2.2/README.md#mean", example: '`d3.mean(waterUsage.map(d => d.waterGallons))`' }, { method: "mean", language: "Python", function: "pandas mean", link: "https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.mean.html", example: "`waterUsage[\"waterGallons\"].mean()`" }, { method: "mean", language: "SQL", function: "AVG", link: "https://www.w3schools.com/sql/sql_where.asp", example: "`SELECT AVG(waterGallons) AS avgGallons FROM waterUsage`" }, {method: "mean", language: "R", function: "mean", link: "https://stat.ethz.ch/R-manual/R-devel/library/stats/html/median.html", example: "`mean(waterUsage$waterGallons)` " }, { method: "mean", language: 'Excel', function: 'AVERAGE', link: "https://support.microsoft.com/en-us/office/average-function-047bac88-d466-426c-a32b-8f33eb960cf6", example: '`=AVERAGE(E:E)` _(if waterGallons is in column E)_' }, { method: "standard_deviation", language: "JavaScript", function: "d3.deviation", link: "https://github.com/d3/d3-array/blob/v3.2.2/README.md#deviation", example: '`d3.deviation(waterUsage.map(d => d.waterGallons))`' }, { method: "standard_deviation", language: "Python", function: "pandas std", link: "https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.std.html", example: "`waterUsage[\"waterGallons\"].std()`" }, { method: "standard_deviation", language: "SQL", function: "STDDEV_SAMP", link: "https://duckdb.org/docs/sql/aggregates.html", example: "`SELECT STDDEV_SAMP(waterGallons) AS sdGallons FROM waterUsage`" }, {method: "standard_deviation", language: "R", function: "sd", link: "https://stat.ethz.ch/R-manual/R-devel/library/stats/html/median.html", example: "`sd(waterUsage$waterGallons)` " }, { method: "standard_deviation", language: 'Excel', function: 'STDEV', link: "https://support.microsoft.com/en-us/office/stdev-function-51fecaaa-231e-4bbb-9230-33650a72c9b0", example: '`=STDEV(E:E)` _(if waterGallons is in column E)_' }, { method: "median", language: "JavaScript", function: "d3.median", link: "https://github.com/d3/d3-array/blob/v3.2.2/README.md#median", example: "`d3.median(waterUsage.map(d => d.waterGallons))`" }, { method: "median", language: "Python", function: "pandas median", link: "https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.median.html", example: "`waterUsage[\"waterGallons\"].median()`" }, { method: "median", language: "SQL", function: "MEDIAN", link: "https://duckdb.org/docs/sql/aggregates.html#statistical-aggregates", example: "`SELECT MEDIAN(waterGallons) AS medWater FROM waterUsage`" }, { method: "median", language: "R", function: "median", link: "https://stat.ethz.ch/R-manual/R-devel/library/stats/html/median.html", example: "`median(waterUsage$waterGallons)`" }, { method: "median", language: 'Excel', function: 'MEDIAN', link: 'https://support.microsoft.com/en-us/office/median-function-d0916313-4753-414c-8537-ce85bdd967d2', example: '`=MEDIAN(E:E)` _(if waterGallons is in column E)_' }, { method: "range", language: "JavaScript", function: "d3.min, d3.max", link: "https://observablehq.com/@d3/d3-extent", example: "`d3.min(waterUsage.map(d => d.waterGallons))`" }, { method: "range", language: "Python", function: "pandas min, max", link: "https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.median.html", example: "`waterUsage[\"waterGallons\"].min()`" }, { method: "range", language: "SQL", function: "MIN, MAX", link: "https://www.w3schools.com/sql/sql_min_max.asp", example: "`SELECT MIN(waterGallons) AS minWater FROM waterUsage`" }, { method: "range", language: "R", function: "min, max", link: "https://stat.ethz.ch/R-manual/R-devel/library/base/html/Extremes.html", example: "`min(waterUsage$waterGallons)`" }, { method: "range", language: 'Excel', function: 'MIN, MAX', link: 'https://support.microsoft.com/en-us/office/calculate-the-smallest-or-largest-number-in-a-range-45fe249f-96c3-443b-8e9f-87f16c48462c', example: '`=MIN(E:E)` _(if waterGallons is in column E)_' }, { method: "count", language: "JavaScript", function: "length property", link: "https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Array/length", example: "`waterUsage.length`" }, { method: "count", language: "Python", function: "pandas shape", link: "https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.shape.html", example: '`waterUsage.shape[0]` _(use [1] to return number of columns)_' }, { method: "count", language: "SQL", function: "COUNT", link: "https://www.w3schools.com/sql/sql_count_avg_sum.asp", example: "`SELECT COUNT(*) AS countRows FROM waterUsage`" }, { method: "count", language: "R", function: "nrow", link: "https://stat.ethz.ch/R-manual/R-devel/library/base/html/nrow.html", example: "`nrow(waterUsage)`" }, { method: "count", language: 'Excel', function: 'ROWS', link: 'https://support.microsoft.com/en-us/office/rows-function-b592593e-3fc2-47f2-bec1-bda493811597', example: '`=ROWS(A2:E237)` _(if data are in columns A through E)_' }, { method: "grouped_mean", language: "JavaScript", function: "d3.rollup, d3.mean", link: "https://github.com/d3/d3-array/blob/v3.2.2/README.md#rollup", example: "`d3.rollup(waterUsage, v => d3.mean(v, d => d.waterGallons), d => d.propertyId)`" }, { method: "grouped_mean", language: "Python", function: "pandas groupby", link: "https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.groupby.html", example: "`waterUsage.groupby(\'propertyId\')[\'waterGallons\'].mean()`" }, { method: "grouped_mean", language: "SQL", function: 'GROUP BY', link: 'https://www.w3schools.com/sql/sql_groupby.asp', example: '`SELECT propertyId, AVG(waterGallons) AS mean FROM waterUsage GROUP BY propertyId`' }, { method: "grouped_mean", language: "R", function: "group_by, summarize", link: "https://dplyr.tidyverse.org/reference/summarise.html", example: "`waterUsage` |`>` `group_by(propertyId)` |`>` `summarize(mean = mean(waterGallons))`" }, { method: "grouped_mean", language: 'Excel', function: 'pivot table', link: 'https://support.microsoft.com/en-us/office/create-a-pivottable-to-analyze-worksheet-data-a9a84538-bfe9-40a9-a8e9-f99134456576', example: '_(Insert > PivotTable)_' }, { method: "grouped_count", language: "JavaScript", function: "d3.rollup, d3.count", link: "https://github.com/d3/d3-array/blob/v3.2.2/README.md#rollup", example: "`d3.rollup(waterUsage, v => d3.count(v, d => d.waterGallons), d => d.propertyId)`" }, { method: "grouped_count", language: "Python", function: "pandas groupby", link: "https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.groupby.html", example: "`waterUsage.groupby(\'propertyId\')[\'waterGallons\'].count()`" }, { method: "grouped_count", language: "SQL", function: 'GROUP BY, COUNT', link: 'https://www.w3schools.com/sql/sql_groupby.asp', example: '`SELECT propertyId, COUNT(waterGallons) AS counts FROM waterUsage GROUP BY propertyId`' }, { method: "grouped_count", language: "R", function: "dplyr count", link: "https://dplyr.tidyverse.org/reference/count.html", example: "`waterUsage` |`>` `count(propertyId)`" }, { method: "grouped_count", language: 'Excel', function: 'pivot table', link: 'https://support.microsoft.com/en-us/office/create-a-pivottable-to-analyze-worksheet-data-a9a84538-bfe9-40a9-a8e9-f99134456576', example: '_(Insert > PivotTable)_' }, { method: "conditional_count", language: "JavaScript", function: "Array filter, length", link: "https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Array/filter", example: "`waterUsage.filter(d => d.waterGallons > 90 && d.propertyId == \"B002\").length`" }, { method: "conditional_count", language: "Python", function: "pandas query, shape", link: "TODO", example: "`waterUsage.query('waterGallons > 90 & propertyId == \"B002\"').shape[0]`" }, { method: "conditional_count", language: "SQL", function: "GROUP BY, WHERE", link: "https://www.w3schools.com/sql/sql_groupby.asp", example: "`SELECT COUNT(*) AS exceedDays FROM waterUsage WHERE waterGallons > 90 AND propertyId = 'B002'`" }, { method: "conditional_count", language: "R", function: "dplyr::filter, dplyr::count", link: "TODO", example: "`waterUsageR` |`>` `filter(waterGallons > 90, propertyId == \"B002\")` |`>` `count()`" }, { method: "conditional_count", language: 'Excel', function: 'COUNTIFS', link: 'https://support.microsoft.com/en-us/office/countifs-function-dda3dc6e-f74e-4aee-88bc-aa8c2a866842', example: '`=COUNTIFS(B2:B237, "=B002", E2:E237,">90")` _(if propertyId is in column B, and waterGallons is in column E)_' }, { method: "percentile", language: "JavaScript", function: "d3.quantile", link: "https://github.com/d3/d3-array#quantile", example: "`d3.quantile(waterUsage.map(d => d.waterGallons), 0.9)`" }, { method: "percentile", language: "Python", function: "pandas quantile", link: "https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.quantile.html", example: "`waterUsage['waterGallons'].quantile(0.9)`" }, { method: "percentile", language: "SQL", function: "quantile_cont", link: "https://duckdb.org/docs/sql/aggregates.html#statistical-aggregates", example: "`SELECT quantile_cont(waterGallons, 0.9) AS quant90 FROM waterUsage`" }, { method: "percentile", language: "R", function: "quantile", link: "https://stat.ethz.ch/R-manual/R-devel/library/stats/html/quantile.html", example: "`quantile(waterUsage$waterGallons, probs = 0.9)`" }, { method: "percentile", language: 'Excel', function: 'PERCENTILE', link: 'https://support.microsoft.com/en-us/office/percentile-function-91b43a53-543c-4708-93de-d626debdddca', example: '`=PERCENTILE(E2:E237, 0.9)`' }, { method: "ranks", language: "JavaScript", function: "d3.rank", link: "https://github.com/d3/d3-array/blob/main/README.md#rank", example: '`waterUsage.map((d, i) => ({...d, rank: d3.rank(waterUsage.map(d => d.waterGallons), d3.descending)[i] + 1}))` _(1 added so that ranks start at 1 instead of 0)_' }, { method: "ranks", language: "Python", function: "pandas rank", link: "https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.rank.html", example: "`waterUsage['rank'] = waterUsage['waterGallons'].rank(ascending=False, method = \"min\")`" }, { method: "ranks", language: "SQL", function: "RANK", link: "https://duckdb.org/docs/sql/window_functions.html#general-purpose-window-functions", example: "`SELECT *, RANK() OVER (ORDER BY waterGallons DESC) AS ranks FROM waterUsage`" }, { method: "ranks", language: "R", function: "rank", link: "https://stat.ethz.ch/R-manual/R-devel/library/base/html/rank.html", example: "`waterUsage` |`>` `mutate(rank = rank(-waterGallons, ties.method = \"min\"))`" }, { method: "ranks", language: 'Excel', function: 'RANK', link: 'https://support.microsoft.com/en-us/office/rank-function-6a2fc49d-1831-4a03-9d8c-c279cf99f723', example: '`=RANK(E2, $E$2:$E$237)`' } ]3d:[{"id":"29ceb515785925b2a475723b7f14e987e3df2bf23d60b7410e6f5267f5f323ec4802bd0a698601bb9d21372693a28a62de89f221af209029eb4495d607d03032","href":"https://static.observableusercontent.com/files/29ceb515785925b2a475723b7f14e987e3df2bf23d60b7410e6f5267f5f323ec4802bd0a698601bb9d21372693a28a62de89f221af209029eb4495d607d03032","name":"conditional-count.png","type":"image/png","lastModified":1678778741639.706,"size":67828},{"id":"4950a2ecdc368d2b9fa2601d11e209dc38b1008187ea668bcd5aa30ae5674f8c63cd99b2e70a305addc3fd0db3d3cfb9639bf5cb3359d62547dcbe72b1b23b9e","href":"https://static.observableusercontent.com/files/4950a2ecdc368d2b9fa2601d11e209dc38b1008187ea668bcd5aa30ae5674f8c63cd99b2e70a305addc3fd0db3d3cfb9639bf5cb3359d62547dcbe72b1b23b9e","name":"count-all@1.png","type":"image/png","lastModified":1678774994904.422,"size":78946},{"id":"c7c63773475966d1df840b3483fd63cb87c11198576523234fe3b26eef1cb62de2582fa3b779ad347d0c17b96f4b5578e25d2fe573b3b1de37d9d2eb090bc301","href":"https://static.observableusercontent.com/files/c7c63773475966d1df840b3483fd63cb87c11198576523234fe3b26eef1cb62de2582fa3b779ad347d0c17b96f4b5578e25d2fe573b3b1de37d9d2eb090bc301","name":"count-by-group@2.png","type":"image/png","lastModified":1678779317987.732,"size":57875},{"id":"4432b68f76972db0fa9122efb5b3843f18ada63f631c426cd14c47c1315787f6b40538242e01783e832ac2bda4f0222d31decdd5dbc315b1132caa5b042f5502","href":"https://static.observableusercontent.com/files/4432b68f76972db0fa9122efb5b3843f18ada63f631c426cd14c47c1315787f6b40538242e01783e832ac2bda4f0222d31decdd5dbc315b1132caa5b042f5502","name":"mean-by-group.png","type":"image/png","lastModified":1678775609330.018,"size":28369},{"id":"f97af27e0cc4e4eb0d94e69a989f2b149ab79c0482eb73db3eacdcb6f1905765cff8d9b0b2fb3394d70062314884c63dae312ff1269188b7c88b563276ba865b","href":"https://static.observableusercontent.com/files/f97af27e0cc4e4eb0d94e69a989f2b149ab79c0482eb73db3eacdcb6f1905765cff8d9b0b2fb3394d70062314884c63dae312ff1269188b7c88b563276ba865b","name":"percentile.png","type":"image/png","lastModified":1678838108505.488,"size":38039},{"id":"59c6b46bccd3f47011cb5c846474d72439bd1a1798b8152f60f523fd8907b0b9d83a58dcb68eebc61cf7abf8f56189aff5141f54b4b266ebe27077a789e94685","href":"https://static.observableusercontent.com/files/59c6b46bccd3f47011cb5c846474d72439bd1a1798b8152f60f523fd8907b0b9d83a58dcb68eebc61cf7abf8f56189aff5141f54b4b266ebe27077a789e94685","name":"ranks.png","type":"image/png","lastModified":1678780580007.449,"size":21307},{"id":"909748cf36e59a3eb62b22f7e20a018f27ed5e29fd62f70ea7d04e0fb1d666ae24becddad6b351629fb21f2636efd064297dea103ee2982c1b9e87d391670343","href":"https://static.observableusercontent.com/files/909748cf36e59a3eb62b22f7e20a018f27ed5e29fd62f70ea7d04e0fb1d666ae24becddad6b351629fb21f2636efd064297dea103ee2982c1b9e87d391670343","name":"sample-mean.png","type":"image/png","lastModified":1678772370390.204,"size":19445},{"id":"68625a2645ac8a4ec17d4563f6588b09319954f656a2bf942b2417a7837b6cfb94f941af6d17879839ccb91023e1415b647e910e8a7652fdd3c1f7d5ca9cdf58","href":"https://static.observableusercontent.com/files/68625a2645ac8a4ec17d4563f6588b09319954f656a2bf942b2417a7837b6cfb94f941af6d17879839ccb91023e1415b647e910e8a7652fdd3c1f7d5ca9cdf58","name":"sample-median.png","type":"image/png","lastModified":1678772654052.325,"size":23753},{"id":"8be5ed58578cdf37fa25fb5c0556b942ffbef3936e6a8ea821b260565b8568ec66f85939ae5f9f387e3f1bc697d0a454720a425ae843d8c13749713c16983dca","href":"https://static.observableusercontent.com/files/8be5ed58578cdf37fa25fb5c0556b942ffbef3936e6a8ea821b260565b8568ec66f85939ae5f9f387e3f1bc697d0a454720a425ae843d8c13749713c16983dca","name":"sample-min-max.png","type":"image/png","lastModified":1678772986379.371,"size":24495},{"id":"09f2951d73e863af2f114955868d8b2432355f55dd5dfe23f80da8a2a8cb5d92b7d41ffe7bbf4ecc7af9b0a06121495d0702fdf75f98181984ce485d35a6ac85","href":"https://static.observableusercontent.com/files/09f2951d73e863af2f114955868d8b2432355f55dd5dfe23f80da8a2a8cb5d92b7d41ffe7bbf4ecc7af9b0a06121495d0702fdf75f98181984ce485d35a6ac85","name":"standard-deviation.png","type":"image/png","lastModified":1678837400004.056,"size":17970},{"id":"f3e481bd7392d91720b0c29b0d8f83ba1ba11d70142cbb2d19c28d8962899180d2369412455068e702f048eec959a42869c7c66ae4b5b553f7be880db4acf756","href":"https://static.observableusercontent.com/files/f3e481bd7392d91720b0c29b0d8f83ba1ba11d70142cbb2d19c28d8962899180d2369412455068e702f048eec959a42869c7c66ae4b5b553f7be880db4acf756","name":"waterUsage.csv","type":"text/csv","lastModified":1678131244549.533,"size":5813}] 3a:{"id":"bbca7bd92474be18","slug":"descriptive-statistics-comparisons-in-java-script-python-sql-r-and-excel","title":"Descriptive statistics: comparisons in JavaScript, Python, SQL, R, and Excel","thumbnail":"16c5dea5b20e556b9b38b2e64fac40cdae1dd37e85ace14b8489fa338378d3bf","access_level":"public","create_time":"$D2026-08-17T14:32:30.619Z","update_time":"$D2026-08-17T14:32:40.209Z","view_time":null,"first_public_time":"$D2026-08-17T14:32:36.345Z","has_unpublished_edits":null,"fork":{"id":"cffe12d0216ee668","slug":"descriptive-statistics-translations","title":"Descriptive statistics: comparisons in JavaScript, Python, SQL, R, and Excel","owner":{"id":"f35c755083683fe5","login":"observablehq","name":"Observable"}},"stars":1,"starred":false,"owner":{"type":"team","id":"0d89ff0d43911832","login":"a-kyselova","name":"a-k","avatar_url":"https://avatars-next.observableusercontent.com/c17731a6346b5dfce53e427b1b871e127393f84a1789e18931f02dc51f940fcc","tier":"starter_2024","bio":"","following":false},"version":887,"publish_version":887,"role":null,"authored":false,"authors":[{"type":"individual","id":"4abdd3c5ac6f602a","login":"akyselova","name":"Anastasiia","avatar_url":"https://avatars-next.observableusercontent.com/f400c814810bb16bc0121a8537885d2f84ff777dc43a704664ad27987b43d9df","tier":null,"bio":"","following":false}],"members":[{"type":"team","id":"0d89ff0d43911832","login":"a-kyselova","name":"a-k","avatar_url":"https://avatars-next.observableusercontent.com/c17731a6346b5dfce53e427b1b871e127393f84a1789e18931f02dc51f940fcc","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":true,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Descriptive statistics: comparisons in JavaScript, Python, SQL, R, and Excel","cells":[{"id":0,"value":"# Descriptive statistics: comparisons in JavaScript, Python, SQL, R, and Excel","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":49,"value":"Here, we compare common descriptive statistics for data analysis (e.g. means, counts, quantiles) across languages. Examples shown use the mock data below (stored as _waterUsage_, which contains information on water usage (gallons), square footage, and number of residents for four different homes (A001, B002, C003 and D004).","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":784,"value":"waterUsage = await FileAttachment(\"waterUsage.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"waterUsage","database":"$undefined"},{"id":176,"value":"
\n## Comparison tables\nThe comparison tables below are not comprehensive; many good (in some cases, better) alternatives exist in each language, and we do not cover myriad caveats (e.g. handling missing values). In general, we use base and tidyverse functions for R examples, pandas functions for Python examples, and DuckDB’s SQL flavor.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":59,"value":"viewof langCheckbox = imageInput()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":554,"value":"

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":180,"value":"---\n${await FileAttachment(\"sample-mean.png\").image({width: 250, align: \"right\"})}\n### Find the sample mean value\nFind the mean of the entire _waterGallons_ column in _waterUsage_.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":77,"value":"$${comparisonTable(filteredFunctions.filter(d => d.method == \"mean\"))}","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":703,"value":"
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":705,"value":"---\n${await FileAttachment(\"standard-deviation.png\").image({width: 250, align: \"right\"})}\n### Find the sample standard deviation\nFind the standard deviation of the _waterGallons_ column in _waterUsage_.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":711,"value":"$${comparisonTable(filteredFunctions.filter(d => d.method == \"standard_deviation\"))}","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":565,"value":"
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":195,"value":"---\n${await FileAttachment(\"sample-median.png\").image({width: 250, align: \"right\"})}\n### Find the median value\nFind the median of _waterGallons_ column in _waterUsage_","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":198,"value":"$${comparisonTable(filteredFunctions.filter(d => d.method == \"median\"))}","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":567,"value":"
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":536,"value":"---\n${await FileAttachment(\"sample-min-max.png\").image({width: 250, align: \"right\"})}\n### Find minimum and maximum values\nReturn the minimum values of _waterGallons_ (syntax for maximum is the same for each).\n\n${comparisonTable(filteredFunctions.filter(d => d.method == \"range\"))}","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":577,"value":"
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":205,"value":"---\n${await FileAttachment(\"count-all@1.png\").image({width: 150, align: \"right\"})}\n### Total observations\nFind the total number of rows (total number of observations, if data are tidy) in _waterUsage_.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":214,"value":"$${comparisonTable(filteredFunctions.filter(d => d.method == \"count\"))}","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":597,"value":"
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":226,"value":"---\n${await FileAttachment(\"mean-by-group.png\").image({width: 250, align: \"right\"})}\n### Find mean values by group\nFind the mean daily water usage by _propertyId_.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":222,"value":"$${comparisonTable(filteredFunctions.filter(d => d.method == \"grouped_mean\"))}","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":602,"value":"
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":228,"value":"---\n${await FileAttachment(\"count-by-group@2.png\").image({width: 250, align: \"right\"})}\n### Count observations by group\nFind the total counts of observations by _propertyId_","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":224,"value":"$${comparisonTable(filteredFunctions.filter(d => d.method == \"grouped_count\"))}","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":615,"value":"
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":315,"value":"---\n${await FileAttachment(\"conditional-count.png\").image({width: 200, align: \"right\"})}\n### Find conditional counts\nFind the total number of days where house B002’s _waterGallons_ exceeds 90 gallons.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":330,"value":"$${comparisonTable(filteredFunctions.filter(d => d.method == \"conditional_count\"))}","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":618,"value":"
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":232,"value":"---\n${await FileAttachment(\"ranks.png\").image({width: 250, align: \"right\"})}\n### Rank values\nAdd a new column containing ranks based on the value in _waterGallons_, with the highest _waterGallons_ value ranked 1. In the case of ties, the minimum rank is used.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":230,"value":"$${comparisonTable(filteredFunctions.filter(d => d.method == \"ranks\"))}","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":674,"value":"
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":237,"value":"---\n${await FileAttachment(\"percentile.png\").image({width: 250, align: \"right\"})}\n### Find percentiles\nFind the 90th percentile value for _waterGallons_.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":234,"value":"$${comparisonTable(filteredFunctions.filter(d => d.method == \"percentile\"))}","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":726,"value":"

\n## Appendix","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":70,"value":"$3c","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":75,"value":"filteredFunctions = compareFunctions.filter(d => langCheckbox.includes(d.language))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":51,"value":"import {imageInput, comparisonTable} from \"@observablehq/data-wrangling-translations\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":55,"value":"import {set} from \"@tophtucker/custom-input-example\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":687,"value":"","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"}],"files":"$W3d","stdlib":"2"}} 3b:"$3a:body"