Python Data Wrangling from a Wikipedia Site, Some SQL Required

$30-250 USD

Selesai

Disiarkan

sekitar 4 tahun yang lalu

$30-250 USD

Dibayar semasa penghantaran

Write a python program that goes to [login to view URL] to fetch the URL for the Wikipedia page for each municipality with a population of 100,000 or more; unless I did something wrong, there are 22 of them. Each of these pages, in turn, has a table that gives the population over time. I want your program to go to each of those pages, in turn, get every census-year/population pair, and store all the data in an SQLite database. Finally —I expect this to be the easy part — execute an SQL command from python to list the cities in decreasing order of their 1960 populations. Save this database, along with the python program.

Python

SQL

ID Projek: 24663500

Tentang projek

10 cadangan

Projek jarak jauh

Aktif 4 tahun yang lalu

Ingin menjana wang?

Alamat e-mel

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda

Dapatkan bayaran untuk kerja anda

Tuliskan cadangan anda

Ianya percuma untuk mendaftar dan membida pekerjaan

Dianugerahkan kepada:

@shantanupython

The actual page you want is this [login to view URL] underscores got replaced somehow So for all municipality data you want mysql database file from my end and the script that will do the job right ? table should not be complicated when is the deadline ?

$75 USD dalam 3 hari

5.0

(68 ulasan)

5.5

10 pekerja bebas membida secara purata $158 USD untuk pekerjaan ini

@zekovicm

Hi there,I am Web Scraping expert from Bosnia & Herzegovina,Europe. I can scrape wikipedia for you . Please feel free to initiate the chat so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan

$175 USD dalam 3 hari

5.0

(43 ulasan)

6.6

@zeshan7929

Hi there, I have scraped some sample data from your link you can also check it. Also i 'll do add into sql database. Please message me to show you scraped data. Thanks

$200 USD dalam 1 hari

5.0

(58 ulasan)

5.5

@anchalsingh0005

Hello, ‌Hope you doing well.I have checked all your requirements and we able to do this and deliver in time.I have 5 years of experience in these types of work. So, I believe we can do that work with your support. ‌Regards

$150 USD dalam 7 hari

4.9

(20 ulasan)

4.9

@cababay

Hello, i am a software architect from Turkey. I have experience on back-end development for about 10 years. I am expert on web scraping with Python. I read your requirements in full and checked the wiki url. Everything looks clear. Please contact me. Thank you!

$140 USD dalam 2 hari

5.0

(27 ulasan)

4.9

@helgekrueger

Hi. I'm a python developer. I've worked with sqlite before storing the data won't be a problem. I've also extracted tables from Wikipedia, so this should also be possible. If you get back to me quickly enough, I might be able to finish today. Otherwise it will take until tomorrow. I look forward to hearing from you Helge Krueger

$167 USD dalam 1 hari

5.0

(14 ulasan)

4.6

@sahilbisla

Dear sir. I have checked your project description and requirements carefully. I will never make you disappointed. If you give me a chance to work with you, I will provide you with high-quality work only for you. I am always ready for you to discuss your project. Best regards!

$100 USD dalam 3 hari

0.0

(0 ulasan)

0.0

@navitajain

Hi, Proficient with web scraping, python, machine learning and SQL. Recently completed a web scraping with text mining project using Python(BeautifulSoup, nltk) and SQL for querying. Let’s have a chat to discuss further about the project. Thanks, Navita

$222 USD dalam 5 hari

0.0

(0 ulasan)

0.0

@jamave

Hi, my name is Javier, i'm an engineer. I've got experience in the differents areas related to your request: python scripting, scraping and database (postgresql, sqlite, mysql, cassandra).

$150 USD dalam 5 hari