User Tools

Site Tools


vd

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
vd [2023/04/12 20:44] – external edit 127.0.0.1vd [2023/05/17 14:00] (current) – [Inspecting Columnar Data] dblume
Line 45: Line 45:
 | F | Frequency table of row counts, or histogram if numeric_binning is true | | F | Frequency table of row counts, or histogram if numeric_binning is true |
  
 +Calculating a percentage-of-total column for a numeric column:
 +
 +^ Key ^ Meaning ^
 +| # | Set column type to "int". |
 +| I | Describe all columns. (Highlight the "sum" cell for the column of interest.) |
 +| ~ | Convert that column to "text" so it'll be copied correctly for pasting later. |
 +| zy | Yank the value of the sum. |
 +| q | Quit the Describe sheet. |
 +| = | New column. Enter ''curcol/'', use Ctrl+y to paste the column sum value. |
 ====== Case Study Link: Exported CSV from PG&E ====== ====== Case Study Link: Exported CSV from PG&E ======
  
vd.txt · Last modified: 2023/05/17 14:00 by dblume