I am in the process where I have to extract the data from the website (there are 5 columns in the beginning), on which i perform the data manipulation.
I need to add 4 more columns into it while data manipulations at the end of it.
When I am extracting the data using data scraping, (and write in excel) I am getting 3 empty columns(without any headers also) in between and when I am adding 4 columns as expected, I am getting total 12 columns instead of 9 columns.
Expectation:- 5 earlier columns + 4 Required columns = 9 columns.
Reality:- 5 earlier columns + 3 un-invited columns + 4 Required columns = 12 columns.
In the above mentioned order.
I need a solution where I can eliminate the 3 un-invited, headerless columns and get the required data.
Thanks and Regards,