VisiData Case Study #2: save data for cities in certain counties as json

Using VisiData v1.1 to select counties from a list of US cities, and saving the resulting data as json suitable for use with Google Maps.

Commands used:

★ 0:50 % to set column type to floating point number
★ 0:55 ! to set a key column (x-axis in the case of a graph)
★ 1:05 . (dot) to plot the current column on the y-axis
★ 1:25 'd' on the canvas deletes the underling rows on the source sheet
★ 1:37 _ (underscore) on the canvas resizes it to fit the whole screen
★ 2:21 gF to get a frequency analysis of two key columns
★ 2:55 / to search in the current column
★ 3:03 'n' to move to the next search match
★ 3:10 's' on the frequency analysis to select source rows
★ 3:47 { and } to move to the prev/next selected row
★ 3:55 " to open a new sheet with only the selected rows
★ 4:07 'gu' to unselect all rows
★ 4:15 - (minus) to hide columns
★ 4:25 # to set column type to integer number
★ 4:32 Ctrl-S to save; extension determines format

[norasalocin]

My god that's a *wonder*. I'm loving this tool and your tutorials, I've been talking about it to my vim-loving peers, this is saving my life!.Thank you!

[ManuelBTC]

4:50 "It was pretty reasonable". Pretty reasonable? Pretty freaking awesome!

[EliotBoonHuat]

Thankyou for another awesome demo of my new favourite tool.

[PotentialEnrgy]

Very powerful examples, thank you so much.

[MrHaste]

It is unfair to other tools that visidata exists, just too good