If the CSV/ text file has different number of columns along the rows, it will fail reading with simple "pd.read_csv(file)".
Instead of it, try naming the columns. It will read until the number of columns supplied.
For example:
df0=pd.read_csv(filename, sep=';',names=['a', 'b', 'c', 'd', 'e'])
It will read only until 5 columns wide.
Some simple tasks are much faster and simpler in pandas than in Excel.
For example: return values that meet some criteria based in other columns.
If we want to list all the basins with area greater than 100ha, a simple code will do.
Assuming we had copied this table from excel:
import pandas as pd
df0=pd.read_clipboard()
df0[df0.iloc[:,-1]>100].to_clipboard()
This code will put the result in the clipboard, to paste back into Excel (for ex.).
