Differences

This shows you the differences between two versions of the page.

--- vd [2021/06/18 13:02]
dblume
+++ vd [2023/04/10 10:27] (current)
dblume
@@ Line 25: / Line 25: @@
 | ; | Extract regex to new column. Ex, ''(video|audio)'', ''(^..)'' or ''(^([STUVW]%%...%%|..))'' |
 | %%^%% | rename the column. Might have to be "product_id" or "platform_id" |
+| = | Use Python function to create new column. Ex, hex to dec: ''int(curcol,16)'' |
+| : | Split column by regex |
 | - | Hide column |
 | S | Go to "Sheets" sheet, to select another sheet to format. |
@@ Line 33: / Line 35: @@
 | , | Select all rows that match this column's value |
 | " | Open duplicate sheet with only selected rows |
+===== Inspecting Columnar Data =====
+^ Key ^ Meaning ^
+| I | Describe all columns, errors, distinct, mode, mean, median, stdev, etc. |
+| i | Add a column of incrementing numbers (useful for '.' charts) |
+| . | Requires an "important" numeric column for row data. Make chart. |
+| O | Options to enable "numeric_binning" and set number of "histogram_bins" (use 'e') |
+| F | Frequency table of row counts, or histogram if numeric_binning is true |
+====== Case Study Link: Exported CSV from PG&E ======
+Visit [[vd-pge]].
+====== Cast Study: Merging Two Tables, logs and metadata ======
 ==== Protip: Use column view to set multiple columns at once ====