Download zip file and read multiple csvs pandas

ZipFile "test. Skip to content. Change Language. Related Articles. Table of Contents. Improve Article. Writing code in comment? Please use ide. Load Comments. What's New. Most popular in Python.

More related articles in Python. The code executes OK. If I run it with 2 or more files in the directory things go wrong from the start. Your guidance would be gratefully appreciated! Nyerguds 4, 1 1 gold badge 29 29 silver badges 58 58 bronze badges. Watty62 Watty62 1 1 gold badge 3 3 silver badges 21 21 bronze badges. No need to skip headers as concatenation will not append multiple headers.

Add a comment. Active Oldest Votes. Connect and share knowledge within a single location that is structured and easy to search. I have a lot of compressed csv files in a directory. I want to read all those files in a single dataframe. This is what I have done till now:.

I have noticed that the above code runs quite fast initially, but it keeps on getting slower and slower as it reads more and more files. How can I improve this? Apply pandas. Instead use suitable os. Skip to content. Change Language. Related Articles.

Table of Contents. Improve Article. Save Article. Like Article.