How to Capture all NSE Bhavcopy (EOD Stock Prices) Files into One File?

Hi Sid can you please tell me the full path of where you have saved all the bhavcopies? For e.g. C:\Users\Yash\Desktop\Python_Files\NSE_Data\Full_Bhavcopy_files

Yash Roongta C:\Users\dhing\python-for-excel-1st-edition\CleanBhavCopy\CleanBhavCopy\data\bhavcopy

I am opening jupyter in C:\Users\dhing\python-for-excel-1st-edition.

Hi, Sid replace "7" with "5" or "6" in your screenshot in the line

csv_file_name = csv_file.split('\\')[7]

Now, why do we do this?

When I was running the code, my path was this mentioned below, when you use .split('\\') function on the below path, it splits everything that comes before and after\\ and converts it into a list.

So, try debugging on your side, print(csv_file) and see the actual path.