improved parsing and imports to pandas dataframe