Smriti Ramakrishnan smram

## howto_paste_tsv_google_sheets
Q: How to paste tab-separated data into Google Sheets
Problem: Google sheets automatically parses CSV data into columns on paste. It doesn't work with TSV - cannot detect tab as a separator automatically, and I cannot figure out how to enter tab as a custom separator.
Solution:
1. Data -> Cleanup Data -> Trim whitespace.
2. Data -> Split text into columns -> Choose space as the separator

## gist:cce12c050e12a8cad93d66c549df422b
# osx
/usr/bin/time -l `ls`

# linux
/usr/bin/time -v `ls`

# from here: https://stackoverflow.com/questions/774556/peak-memory-usage-of-a-linux-unix-process

## pandas_newline_strip.txt
# got to handle both escaped and literal

df.replace(to_replace=[r"\\t|\\n|\\r", "\t|\n|\r"], value=["",""], regex=True, inplace=<INPLACE>)
	Q: How to paste tab-separated data into Google Sheets
	Problem: Google sheets automatically parses CSV data into columns on paste. It doesn't work with TSV - cannot detect tab as a separator automatically, and I cannot figure out how to enter tab as a custom separator.
	Solution:
	1. Data -> Cleanup Data -> Trim whitespace.
	2. Data -> Split text into columns -> Choose space as the separator
	# osx
	/usr/bin/time -l `ls`

	# linux
	/usr/bin/time -v `ls`

	# from here: https://stackoverflow.com/questions/774556/peak-memory-usage-of-a-linux-unix-process
	# got to handle both escaped and literal

	df.replace(to_replace=[r"\\t\|\\n\|\\r", "\t\|\n\|\r"], value=["",""], regex=True, inplace=<INPLACE>)