title: Pandas read_csv: Columns are being imported as rows
body: <p><strong>Edit</strong>: I believe this was all user error. I have been typing <code>df.T</code> by default, and it just occurred to me that this is very likely the TRANSPOSE output. By typing <code>df</code>, the data frame is output normally (headers as columns). Thank you for those who stepped up to try and help. In the end, it was just my misunderstanding of pandas language..</p>
  
  <p><strong>Original Post</strong></p>
  
  <p>I'm not sure if I am making a simple mistake but the columns in a .csv file are being imported as rows using <code>pd.read_csv</code>. The dataframe turns out to be 5 rows by 2000 columns. I am importing only 5 columns out of 14 so I set up a list to hold the names of the columns I want. They match exactly those in the .csv file. What am I doing wrong here?</p>
  
  <pre><code>import os
  import numpy as np
  import pandas as pd
  
  fp = 'C:/Users/my/file/path'
  os.chdir(fp)
  
  cols_to_use = ['VCOMPNO_CURRENT', 'MEASUREMENT_DATETIME',
                 'EQUIPMENT_NUMBER', 'AXLE', 'POSITION']
  
  df = pd.read_csv('measurement_file.csv',
                   usecols=cols_to_use,
                   dtype={'EQUIPMENT_NUMBER': np.int,
                          'AXLE': np.int},
                   parse_dates=[2],
                   infer_datetime_format=True)
  </code></pre>
  
  <p>Output:</p>
  
  <pre><code>                                    0  ...            2603
  VCOMPNO_CURRENT                T92656  ...          T5M247
  MEASUREMENT_DATETIME  7/26/2018 13:04  ...  9/21/2019 3:21
  EQUIPMENT_NUMBER                  208  ...             537
  AXLE                                1  ...               6
  POSITION                            L  ...               R
  
  [5 rows x 2000 columns]
  
  </code></pre>
  
  <p>Thank you.</p>
  
  <p>Edit: To note, if I import the entire .csv with the standard <code>pd.read_csv('measurement_file.csv')</code>, the columns are imported properly.</p>
  
  <p>Edit 2: Sample csv:</p>
  
  <pre><code>VCOMPNO_CURRENT,MEASUREMENT_DATETIME,REPAIR_ORDER_NUMBER,EQUIPMENT_NUMBER,AXLE,POSITION,FLANGE_THICKNESS,FLANGE_HEIGHT,FLANGE_SLOPE,DIAMETER,RO_NUMBER_SRC,CL,VCOMPNO_AT_MEAS,VCOMPNO_SRC
  T92656,10/19/2018 7:11,5653054,208,1,L,26.59,27.34,6.52,691.3,OPTIMESS_DATA,2MTA ,T71614 ,RO_EQUIP     
  T92656,10/19/2018 7:11,5653054,208,1,R,26.78,27.25,6.64,691.5,OPTIMESS_DATA,2MTA ,T71614 ,RO_EQUIP     
  T92656,10/19/2018 7:11,5653054,208,2,L,26.6,27.13,6.49,691.5,OPTIMESS_DATA,2MTA ,T71614 ,RO_EQUIP     
  T92656,10/19/2018 7:11,5653054,208,2,R,26.61,27.45,6.75,691.6,OPTIMESS_DATA,2MTA ,T71614 ,RO_EQUIP     
  T7L672,10/19/2018 7:11,5653054,208,3,L,26.58,27.14,6.58,644.4,OPTIMESS_DATA,2CTC ,T7L672 ,BOTH         
  T7L672,10/19/2018 7:11,5653054,208,3,R,26.21,27.44,6.17,644.5,OPTIMESS_DATA,2CTC ,T7L672 ,BOTH             
  </code></pre>