Find Jobs
Hire Freelancers

Data Analysis via Scripting with Web Interface

$30-250 USD

Dibatalkan
Dibuat sekitar 8 tahun yang lalu

$30-250 USD

Dibayar ketika dikirim
Objective: Design a simple interface to report the shared destination urls created by placing a url on a source url. Inputs: 1. Data spreadsheet. All data is currently in the form of a shared online excel type worksheet where column H will be called “source_url”, and column I will be called “dest_url”. This file can be exported to MS Excel Workbook (.xlsx), OpenDocument Spreadsheet (.ods), Comma Separated Values (.csv), or Tab Separated Values (.tsv). 2. User will give a list of source_urls that will always be a sub-set of the source_urls in column H of the data above. We will call this list of source_urls “list_x” 3. User will give a single dest_url that may or may not be a sub-set of the dest_urls in column I of the data above. We will call this dest_url “dest_x”. Desired output: On every line of the data spreadsheet (input 1) there will be an entry for source_url and dest_url. Each unique source_url should build a list of dest_urls that are associated with it until every line of the data spreadsheet is read. The first step is check each source_url in list_x to see if dest_x is already associated with it. This means that if dest_x is the same as one of the dest_url associated with source_url, that source_url from list_x is not eligible. The remaining list should be a sub-list of list_x, where each entry is not associated with dest_x. The next step is to find a complete list of source_urls (not a part of list_x) that ARE associated with dest_x from the data spreadsheet, we’ll call this list “list_shared”. Once you have that list, you want to know how many common dest_urls are shared between the source_url from list_x and the source_url from list_shared. If there are no other source_urls in the data spreadsheet that are associated with dest_x, all items in user inputted list_x are considered to have “0” shared sources and should be reported as so. Example: Data spreadsheet: Column H Column I source_a dest_apple source_b dest_orange source_c dest_orange source_a dest_banana source_b dest_banana source_c dest_banana source_x dest_orange source_y dest_orange source_z dest_x source_a dest_x source_b dest_x source_c dest_x source_x dest_banana source_y dest_grape source_z dest_grape source_d dest_x source_e dest_orange source_f dest_banana User Inputs: source_URLs: dest_url: source_x dest_x source_y source_z Note: The inputs should be put into two graphical boxes in a web interface. The source_url box should support a list separated by newlines. The dest_url should support 1 line of text.   Output: Note: The output should be graphical highlighting the user input source_url with the lowest number of shared sources. If there are more than one source_url that has the lowest number of shared sources, they should all be highlighted. Ineligible sources should be red or grayed out. See attached image. For debugging, a text output should also be supported. Example: If dest_x is placed on: source_z is not eligible for placement. source_x will share 3 destinations with 2 sources will share 2 destinations with 1 source will share 1 destination with 1 source source_y will share 3 destinations with 0 sources will share 2 destinations with 2 sources will share 1 destination with 1 source Notes: For debugging purposes the first iteration of this program should be able to output the specific names of the shared “destinations” and the other “sources”. All URLs should have the preceeding characters “http://”, “https://”, “http://www.”, “www.”, etc. AND any trailing “/” ignored when pattern matching. Eg. http://www.source_a www.source_a source_a/ should all be recognized as the same URL.
ID Proyek: 10045184

Tentang proyek

6 proposal
Proyek remot
Aktif 8 tahun yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan
6 freelancer menawar dengan rata-rata $368 USD untuk pekerjaan ini
Avatar Pengguna
Hello I am Software Engineer and expert in Software Development so you can discuss the Project functionalr equirements In details Thanks I will wait for your quick Response
$333 USD dalam 15 hari
5,0 (6 ulasan)
3,3
3,3
Avatar Pengguna
Hi! We have an extensive experience in Perl programming. Working with Excel, refining ULRs, highlighting the text etc - everything can be done. Our team consists of 7 specialists, 3 of which have a PhD degree (2 in Mathematics, 1 in Biology). We have fulfilled more than 70 contracts for different Russian government agencies. We have a good command of English. Regards, Novikov Dmitry
$222 USD dalam 2 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
We have a team of expert DB Architects and Website designers and developers with more than 10 years of rich industry experience & would be more than happy to work on the project. We have expertise in designing and delivering complex business solutions. Our core expertise includes MY SQL, ORACLE, SQL SERVER, Java, PHP, .NET, Python, R, C, C++. Recently we have delivered a web crawler. In one of our ongoing projects, we are implementing Telecom protocols in java. We have 100% completion rate,please check our reviews to have an idea about the quality of work we have delivered in the past. If given a chance I assure you of the best quality work within time and budget.
$377 USD dalam 3 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
A proposal has not yet been provided
$444 USD dalam 7 hari
0,0 (0 ulasan)
0,0
0,0

Tentang klien

Bendera UNITED STATES
United States
0,0
0
Anggota sejak Mar 25, 2016

Verifikasi Klien

Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.