mixed types

[MattT]

I have mixed data types when trying to load in several CSV files into jupyter notebook. How can I fix this? Thanks for any help

Code

import os
import glob
import pandas as pd
os.chdir("M:\My Folder\Trial")
extension = 'csv'
all_filenames = [i for i in glob.glob('*.{}'.format(extension))]

combined_csv = pd.concat([pd.read_csv(f) for f in all_filenames ])

Here is my error

Error:
C:\Users\xxxxxx\AppData\Local\Continuum\anaconda3\lib\site-packages\IPython\core\interactiveshell.py:3249: DtypeWarning: Columns (2,8) have mixed types. Specify dtype option on import or set low_memory=False.
  if (await self.run_code(code, result,  async_=asy)):

[Larz60+]

this looks suspiciously like you are running out of memory.

[MattT]

Looks like this may of solved it:

combined_csv = pd.concat([pd.read_csv(f, sep=',', error_bad_lines=False, index_col=False, dtype='unicode') for f in all_filenames ])