title: how to read multiple csv files in a directory through python csv() function?
body: <p>In one of my directory, I have multiple CSV files. I wanted to read the content of all the CSV file through a python code and print the data but till now I am not able to do so. </p>
  
  <p>All the CSV files have the same number of columns and the same column names as well.</p>
  
  <p>I know a way to list all the CSV files in the directory and iterate over them through "os" module and "for" loop.</p>
  
  <pre><code>for files in os.listdir("C:\\Users\\AmiteshSahay\\Desktop\\test_csv"):
  </code></pre>
  
  <p>Now use the "csv" module to read the files name</p>
  
  <pre><code>reader = csv.reader(files)
  </code></pre>
  
  <p>till here I expect the output to be the names of the CSV files. which happens to be sorted. for example, names are 1.csv, 2.csv so on. But the output is as below</p>
  
  <pre><code>&lt;_csv.reader object at 0x0000019F97E0E730&gt;
  &lt;_csv.reader object at 0x0000019F97E0E528&gt;
  &lt;_csv.reader object at 0x0000019F97E0E730&gt;
  &lt;_csv.reader object at 0x0000019F97E0E528&gt;
  &lt;_csv.reader object at 0x0000019F97E0E730&gt;
  &lt;_csv.reader object at 0x0000019F97E0E528&gt;
  </code></pre>
  
  <p>if I add next() function after the csv.reader(), I get below output</p>
  
  <pre><code>['1']
  ['2']
  ['3']
  ['4']
  ['5']
  ['6']
  </code></pre>
  
  <p>This happens to be the initials of my CSV files name. Which is partially correct but not fully. </p>
  
  <p>Apart from this once I have the files iterated, how to see the contents of the CSV files on the screen? Today I have 6 files. Later on, I could have 100 files. So, it's not possible to use the file handling method in my scenario.</p>
  
  <p>Any suggestions?</p>