title: how to concatenate two csv files?
body: <p>I have two csv files and I want to make them to be one csv file</p>
  <pre>
  df1:
        aa  bb  cc   
     0  65  33  A
     1  50  32  B
     2  40  23  C
  
  df2:
        0   1   2   
     0  70  40  7
     1  50  30  8
     2  40  23  9
  </pre>
  <p>the result should like this:</p>
  <pre>
        aa  bb  cc  0   1   2
     0  65  33  A   70  40  7
     1  50  32  B   50  30  8
     2  40  23  C   40  23  9
  
  but I get this:
        aa  bb  cc Unnamed  0   1   2
     0  65  33  A     0     70  40  7
     1  50  32  B     1     50  30  8
     2  40  23  C     2     40  23  9
  </pre>
  <p>here's my code:</p>
  <pre class="lang-py prettyprint-override"><code>df_new = pd.concat([df1, df3], axis=1)
  result = df_new.to_csv(&quot;C:/Users/AZ/.spyder-py3/DATASET1/new.csv&quot;)
  </code></pre>
  <p>Can anyone help?</p>