1. An Excel file with a column containing phone models is provided as input. For example: Vivo T4
2. We iterate through the Excel rows and on the website https://phonedady.com search for this device.
3. The search is conducted as follows (comparison without spaces):
a) if there is a 100% match - analyze this result
b) if the result is not a 100% match (our string is contained within the result string but is shorter than the result) AND there is 1 search result - take it. Example of a search result:
- Vivo T4 GTX
In this case, analyze it.
c) if the result is not a 100% match (our string is contained within the result string but is shorter than the result) AND there are more than 1 search results - return None (i.e., no match found). Example of search results:
- Vivo T4 X
- Vivo T4 5G.
In this case, do not return anything (because it is unclear which one to choose).
4. Analysis of the result (the webpage that opens for the found device):
a) take the device price (on the page, the field is price in USD)
b) take the device technical model (on the page, the field is Models)
5. Output an Excel file with the following columns:
a) model name Vivo T4
b) price
c) technical model number (if there are multiple - duplicate the rows).
