Find Jobs
Hire Freelancers

Download Database from website

$10-30 USD

Completed
Posted about 8 years ago

$10-30 USD

Paid on delivery
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.
Project ID: 10392829

About the project

20 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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
User Avatar
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
$34 USD in 1 day
4.9 (251 reviews)
6.7
6.7
User Avatar
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
$35 USD in 1 day
4.9 (52 reviews)
5.2
5.2
User Avatar
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..
$25 USD in 1 day
4.9 (51 reviews)
5.3
5.3
User Avatar
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.
$40 USD in 1 day
5.0 (23 reviews)
5.4
5.4
User Avatar
A proposal has not yet been provided
$30 USD in 1 day
4.9 (27 reviews)
4.6
4.6
User Avatar
Sir its very easy for me so please contact me,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Thanks
$20 USD in 1 day
4.8 (44 reviews)
4.4
4.4
User Avatar
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
$50 USD in 3 days
5.0 (36 reviews)
4.3
4.3
User Avatar
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!
$30 USD in 2 days
4.8 (47 reviews)
4.5
4.5
User Avatar
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.
$30 USD in 1 day
4.9 (14 reviews)
3.4
3.4
User Avatar
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
$25 USD in 1 day
4.9 (5 reviews)
2.4
2.4
User Avatar
I posses effective planning and organizational skills coupled with high work ethic, high accuracy to detail and a 100% completion rate.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
hello, i am sharwar, i have experience in data entry work, i have enough time to do this work. moreover i can start your project from right now.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Stanford, United States
5.0
5
Payment method verified
Member since Jan 28, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.