Hi.
I would like to have your advice regarding adding information to data table which is obtained from “Datascratping” action.
I need to obtain several data from a website such as following.
My current program search for, for example, purchase information of “Product A” and “Product B”. Both data will be as following;
Product-A customer | Price |
---|---|
HHHHH | 20000 |
CCCCC | 4500 |
FFFFFF | 7500 |
DDDDD | 5000 |
GGGGG | 15000 |
YYYYY | 4500 |
IIIIIII | 7500 |
UUUUU | 20000 |
JJJJJ | 4500 |
Product-B customer | Price |
---|---|
CCCCC | 4500 |
DDDDD | 5000 |
FFFFFF | 7500 |
GGGGG | 15000 |
HHHHH | 20000 |
IIIIIII | 7500 |
JJJJJ | 4500 |
UUUUU | 20000 |
YYYYY | 4500 |
What I would like to do is combine both data and also add product name on column C such as following;
customer | Price | Product |
---|---|---|
HHHHH | 20000 | A |
CCCCC | 4500 | A |
FFFFFF | 7500 | A |
DDDDD | 5000 | A |
GGGGG | 15000 | A |
YYYYY | 4500 | A |
IIIIIII | 7500 | A |
UUUUU | 20000 | A |
JJJJJ | 4500 | A |
CCCCC | 4500 | B |
DDDDD | 5000 | B |
FFFFFF | 7500 | B |
GGGGG | 15000 | B |
HHHHH | 20000 | B |
IIIIIII | 7500 | B |
JJJJJ | 4500 | B |
UUUUU | 20000 | B |
YYYYY | 4500 | B |
※ I need column C because in the end I need to make a pivot data. |
My current program just over-writes when downloading the data table of Product B.
So my questions are below 2 points.
1)How should I set up to add column C information? I need to know how to specify the start and end of the table.
2)How could I set up to write the product B information comes under that of product A without over-writing?
Please let me know if I do not make myself understood.
Thank you in advance for your help and advise!
Best,
Carmen