Filtering in excel using a list of values

https://www.extendoffice.com/documents/excel/3186-excel-filter-rows-by-list.html

Adding a character/string at the end of all lines in a file Linux

sed 's/$/<characters>/' filname

Most frequently occuring data in a row

=INDEX(B2:D2,MODE(MATCH(B2:D2,B2:D2,0)))

can be used for example to count votes

Splitting a colum into multiple columns Excel

=INDIRECT("Sheet1!R" & (ROW()-1)*3+1 & "C1", FALSE)


Say you have a long oclumn of data. You want to split it  into 3 columns such that, every third element  goes into each column.  for example youd data is: AAABBBCCCDDDEEEFFFGGGHHH
you want to split into 3 columns : ABCDEFGH, ABCDEFGH, ABCDEFGH. use the above formula

remove spaces in foldernames in linux

find -name "* *" -type d | rename 's/ /_/g' 

Opening a html table in excel

just use open with- and select Excel. As simple as that!

making global open-cv module available in a venv

This post is pefect.
http://stackoverflow.com/questions/13312139/opencv-and-python-virtualenv/19213369#19213369