code Archives - Peter Bakke

April 17, 2018

Excel and .csv lesson learned… Includes painful waste of time, unfortunately.

I found out that when you export data in .csv format from #Excel make sure you don’t have a trailing space after any column names. They are exported as “col_name ” with the space AND quotes. Beware when using them to index your array! They will fail. Simply delete any hidden spaces in your column names before exporting. Please. For your own sanity. #DataAnalytics #ERROR #painful lesson.

April 7, 2018

Python Immutable strings, integers, booleans

In Python, STRINGS, INTS, BOOLs etc. are IMMUTABLE… meaning, for example, that you cannot convert a df column that is a string to a column that is int. However, you can ASSIGN the values (objects) to another variable or create a new instance of that column in another dataframe … or use .astype(int) to perform an intermediate computation.