Comment by Sid on "How to Capture all NSE Bhavcopy (EOD Stock Prices) Files into One File?" | Hashnode

Sid

Jul 7, 2021

The following error is coming while cleaning the data. Pls guide.

Yash Roongta

Finance & Coding Enthusiast

Jul 7, 2021

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

Sid

Jul 7, 2021

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.

Yash Roongta

Finance & Coding Enthusiast

Jul 7, 2021

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.

Search Hashnode