Freelancers,
I need someone who can extract a database from a website. I have also uploaded a PDF with with pictures of how extract the database.
Steps:
1. Go to the following website: [login to view URL]
2. In the drop down menu on the top, switch from "Información hasta Entidad Federativa y Clase de Actividad" to "Información hasta Municipio y rama de Actividad".
3. To your left you will see a box titled "Contenido".
Start by expanding the group called "Indicadores".
Expand the Subgroup called "F- Gastos por consumo de bienes y servicios". Check the boxes from F02 to F19.
Now expand the subgroup group called "G- Ingresos por suministro de bienes y servicios". Check the boxes from G01 to G07.
4. Proceed to " A - Año Censal", which is the next element in the "Contenido" box. Check the box that reads "Los 3 años más recientes". After you do that, you will notice that there is a new element in the box titled "Area de Columnas". Press the filtering icon, which will open a new window. In this new window you will find a new menu with a box that reads "Todos los miembros". Check Only the box that reads 2009. (Uncheck 204 and 2014).
5. Proceed to the next element in the "Contenidos" box, which will read "B-Cobertura Geográfica". Open this group and check the box that says "Municipios". Do not check the box that says "Entidades".
6. Proceed to the next element in the "Contenidos" box, which will read "C-Actividad Económica". Check the box that says "Ramas". Leave the other 2 boxes unchecked.
7. In the "Area de filas" box, click and drag "C3 - Ramas" and put it on top of "B2 - Municipios".
8. Press the button next to the "Contenido" title, which reads "Consultar" (Consult or Generate). The page will load a data table with the filters that we have selected so far.
9. The table will display the different industry sectors ("Ramas"), and will give you the option to expand those sectors by geographic area ("Municipios") by clicking a "+" icon. Go ahead and press the "+" icon for the first 6 or 8 "Ramas". You will see that the table data will expand to show additional data. Because of the way that this website is programmed, one cannot this level of detail without clicking on the "+" icons for each "Rama".
10. After you expand a small group of "Ramas" by clicking on their "+" (expansion) icon, click the "Microsoft Excel" icon on the top of the website to extract the database of the "Ramas" you have expanded. This will generate a database for you to download.
11. Open the Excel database you just downloaded. You will see that only the "Ramas" you expanded have the detail of the municipalities. The purpose of this data base extraction is to have the detail for all the "Ramas". That requires you to expand the detail of the ramas in step 9 for all the "Ramas" in the 9 pages.
You will notice that attempting to download a big selection of expanded "Ramas" at a time will result in the website to crash. This is important, because it will require you to expand a limited number of "Ramas" at a time, download that information, close the expansion of the previous Ramas and move on expanding the next group of "Ramas" to download.
You should make sure that the database that you are putting together is clean, and only has entries for ramas that show the detail of the municipalities, not the ones that only show the aggregated values for the ramas.
12. The final deliverable should be a clean database with the content of the "Ramas" and their detail per "Municipio".
13. After you finish with this selection. Go back to step 4 and do this all over again but only checking the box for 2014.
Extremely important: Selecting a large number of ramas and attempting to download them at the same time will cause the website to crash. This means that you will have to do steps 1 to 10 all over again. Avoid that by downloading few "Ramas" at a time.
Hope you doing great!
Your project may take less time but I'm just putting 3 days approximately.
I'm a qualified person, visit my profile.
Kind Regards
$15 USD in 3 days
0.0 (0 reviews)
0.0
0.0
20 freelancers are bidding on average $27 USD for this job
Hello Dear,
HERE Ready to start!!!,
I have read your project description and I’m an expert on these jobs
and willing to start it right now!
I Look forward to hearing from you.
Regards
Maariyaa
Dear sir,
Greeting,
Old account has been closed new account start work.
I've extensive experience doing the work very fast and accurate .I'll try able to make you 100% satisfactory and it will be a great result of my work.
Ready to start now.
My success always measure with client's satisfaction. So, i always try to do the best.
Please let me know if you have any questions.
sincerely,
sujonmax2
Hi there, I have read the project & would like to discuss..
I have good web scraping skills in Python & can make web scraping scripts in Python..
Hope to hear from you..
Hello.
I hope do your project.
I take an interest in Web Scrping.
I have full skills in Web scraping, Android, Iphone, Reverse engineering, Qt, c++ & c# programming.
Please check my profile and portfolio.
I'd be happy to keep long partnership,if you'd like.
Looking forward for your kind answer.
Best Regards.
Yknox.
Sir its very easy for me so please contact me,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Thanks
I have 7 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases.
And also I have worked on extraction with websites like Amazon, Cellpex,Costco,Yellowpages,Yelp,etc.,
hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction, and the price is negotiable if required.
please award me this project and contact me for further details
Dear Sir/Madam,
I am very interested to this project. I have good experience on Data Entry & Internet Research. I believe in hard working and ready to give best quality work before the deadline. I have done this kind of work in past.
***Please contact with me to discuss more details.***
Thank you!
Hi i am Sabbir. I will give you a best quality work..
I can complete this job in a short time ..
Before award me or hire me i will show you a trail work..
I am Well Experience in data entry...
I have done some similar projects,
kindly give me a reply will wait for your reply
thank you.
Hello,
I am pretty much interested to do this job for you . I can give you a better performance if you select me the right one. Looking forward to you.
Thanks for your time
Md. Mehebub Hossain
I am an ex-programmer that is very familiar with databases as well as Office products. I will be able to create a clean database from the data from the website for you. I look forward to working with you. Thank you for your consideration.