Parcing the website of spending materials in the XLSX file

Data Parsing — incorrectly specified categories?

15 USD

Client's review of cooperation with Vadim Savchuk

Parcing the website of spending materials in the XLSX file

15 USD

Excellent thoughtful work on the result + adequate time assessment. In the process of work there were defects, which were eliminated without the translation of the shooters. The most important thing, Vadim has a very valuable option, which lacks the majority of performers - he is always in contact, does not hide the number and informs about the course of work. If you need parsing and data analysis with a guaranteed result, contact Vadium.

5.0

Yury Smirnov

Reciprocal Feedback

28 July 2018

Freelancer's review of cooperation with Yury Smirnov

Parcing the website of spending materials in the XLSX file

15 USD

clearest task setting, decent payment, positive attitude - I wish everyone such a customer!

5.0

Vadim Savchuk

Reciprocal Feedback

28 July 2018

Project translated automatically. Log in or register, to view the original The website of Rashodnika.net An example of the resulting file is applied.Explanations for each column - there are.Consistency:We consistently run through the tree of catalogues (left) On the right side of the page: [printer models], grouped by series - they are interested in us.We are working with each printer model.At this stage we have already collected data for the first 5 columns of the table - this is the information about the printers.The page of each printer contains a table with a list of the cartridges that fit it.From here we get only the “Producer Code”.On different pages it can be in one or two cells - that's how you need to keep it in a file (see.the example).The first column of the table is always empty.The name of the cartridge is ignored.At this stage, we received the data in two other columns of the table: "Code 1" and "Code 2".HIGH: most printers will have several cartridges.For each cartridge there is a separate line in the file.The information about the printer (first 5 columns) is duplicated.This is clearly seen in the example.We go to the page of each map and collect information about it, filling the remaining columns.Below some explanations:image: we draw one image and save its nameColor we pick up the name "Color" in the characteristics tab - by entering the word "Resource" in one of their characteristics.It may contain an arbitrary name, but in any way, it contains the word "Resource".In this case, the value is placed in one cell and the indication (full) is in the other.This is seen in the example.If the resources are a few, we take the first one.To make the work easier, only the result of the work of the parser is needed.The site may block IP.You need to be ready to go through a VPN, for example.