title: Reading CSV using python to store in GCP Big query
body: <p>I'm new to Python and GCP , working on loading data from CSV using Python to Big Query.</p>
  <p>Sample program is working fine using this documentation -
  <a href="https://cloud.google.com/bigquery/docs/loading-data-cloud-storage-csv" rel="nofollow noreferrer">https://cloud.google.com/bigquery/docs/loading-data-cloud-storage-csv</a></p>
  <p>I'm getting data from other data base by creating CSV file , when I look at the data in Excel it looks good but in Textpad or notepad , if there are any extra spaces in the values like '  myname' instead of 'myname' it's reading as next row instead of single row ..by doing so it's give me extra row with less column..error - csv table references column position 1234 but line starting at position 12345 contains only 9 columns instead 10 columns..</p>
  <p>Example :
  Big Query Table :</p>
  <p>Column A
  Column B
  Column C</p>
  <p>CSV File Data:</p>
  <p>Name,Test,Text
  Name, Test2,Text - This link in Excel looks good ..going to 3 different columns but when I look at in Text pad it shows as Name,&quot; - This in 1 row
  Test2,Text --This data in another row</p>
  <p>1 split into 2 rows..how to avoid these while reading data from CSV using python .</p>
  <p>Pls advice.</p>
  <p>Thanks</p>