Python code to work with Excel files
Note: The instructions are for python3.x on Ubuntu There are several different libraries you can use to easily work with Excel. I will be covering openpyxl. Other options include xlsxwriter, xlrd,…
Excel: how to transpose data
The following steps show how to transpose data in excel. Transposition refers to switching between rows and columns. For example, if row 1, column1 is A, row 2, column 2…
Removing characters from Excel cells
Sometimes Excel cells contain unwanted data. Removing this data can be a very tedious job. For example, I recently received a data file where the first column cells contained some…