title: How to parse a CSV file as with commas or pipes and read into a data frame?
body: <p>I am trying to loop through multiple CSV files in a folder and parse each file into a data frame then get the data type for each field.  Before I can even get to the loop, I'm trying to parse a single CSV file, and I'm encountering some issues.  This is what I'm working with now.</p>
  
  <pre><code>import pandas as pd
  # CSV file
  csv_file = 'C:\\path\\ARMINDEX.CSV'
  # read cvs with pandas read_csv
  df = pd.read_csv(csv_file)
  df.dtypes
  </code></pre>