Need a tool or solution to filtering a 22GB JSON file

$30-250 USD

Selesai

Disiarkan

sekitar 4 tahun yang lalu

$30-250 USD

Dibayar semasa penghantaran

Hi, I need someone that can create a tool or help me to set up a solution to let me filter my JSON database. I have attached a sample of the file. I will work with 3 columns from this database; Keyword, URL and Title. I need to be able to filtering with specific parameter like; Example of queries: 1. Show only rows that the URL include "coffee" in URL. 2. Show only rows that the domain name include "coffee" (For this query, it will research in the URL column but only in the domain name, not the entire URL. ([login to view URL], in this example, the query should look for "[login to view URL]" only and not "[login to view URL]". 3. Show only rows that the title include "coffee". 4. Show only rows that the title and full URL include "coffee". 5. Show only rows that the title and domain include "coffee". Once I have the results.. I want to be able to export it in excel format.

ID Projek: 25160370

Tentang projek

12 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:

@expertcoder1vw

Hi, The solution is to import the JSON file first to a database, and then perform your queries on the database, and export from the results. I can develop a Windows application, with a local MySQL database , to do this for you. Delivery in 1 week or less. Good quality work done. Thanks for considering me. Bests, Steve

$200 USD dalam 7 hari

5.0

(42 ulasan)

6.0

12 pekerja bebas membida secara purata $187 USD untuk pekerjaan ini

@Daniel655

Hello! I already review your json sample file, I can develop a desktop app in C# to extract the json rows applying the filters to the domain only or the full url, Please contact me.

$250 USD dalam 7 hari

5.0

(2 ulasan)

6.4

@mandalsaubhik

i'm checking the file you have attached in the project description. i think i can have a solution for your requirement about filtering. do you want to filter in database or a json file?

$140 USD dalam 3 hari

4.9

(52 ulasan)

6.3

@NewHorizons2016

Hello there, I offer MS WIndows based tools to process JSON , XML and other data format-based (text based) databases. Since your database is 22 GB large, it wouldn't be wise to store it all in memory, and hence would require a programming language that can perform JSON text parsing in-memory, in small chunks at a time, or using some other algorithm; and a programming language such as C/C++ which is ideally suited to processing large databases , including this JSON database ; before querying it. I should be able to assist, but the sample you have provided is not valid JSON, firstly; but it looks fine when visually inspected. Do read thru My profile first, to acquaint your self with My background first, should you decide to respond to My proposal... Cheers Dinesh

$500 USD dalam 7 hari

5.0

(12 ulasan)

5.5

@periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred and twenty five excel vba projects in couple of years. Willing and looking forward to working with you. Thank you, Regards.

$140 USD dalam 3 hari

5.0

(33 ulasan)

5.3

@tutulsoft

-- JSON Expert --------------- I have solution for you ---- i can extract as you describe from the sample JSON file ---can you come on CHAT ---thanks

$195 USD dalam 3 hari

4.9

(26 ulasan)

5.5

@IshaqKN

Hi there, Yes sure. Let me handle your task in Python. Will deliver standalone GUI too. And yes file size won't matter. Exp in data processing + regex. Will glad to work on it. Best regards, Ishaq

$100 USD dalam 3 hari

5.0

(29 ulasan)

4.6

@tytus0d

I have more than 15 years experience of Delphi Developer. I started with Delphi 5 and working with XE10.3 Rio now. I have experience in Windows API, Network API, COM-Port, DataSnap, Client/Server, parsing big files, develop Multi-threaded application without any memory/resource leaks. Oracle Database (from 8i to 12c), SQL, T-SQL, MySQL, MSSQL. Also I have some experience in C++ and C# programming languages.

$120 USD dalam 7 hari

5.0

(3 ulasan)

2.9

@experthours

Hi! I am skilled Swift computer programmer with skills including Software Development, JSON, PHP, MySQL and C# Programming. Please send a message to discuss more regarding this project. Thank you

$155 USD dalam 7 hari

5.0

(2 ulasan)

2.2

@pratikgedia

Hi There, Hope you doing well. I have understood the requirement and can provide you a code with minimal dependency. At the end of the transformation of the job you will be getting an excel file with the desired result. As a Data Engineer have done several such projects with not only GB's of Data but also data in TB's. Could we please have a bit of discussion and allow me work on it. Looking forward to hear from you soon. Thanks, Pratik

$100 USD dalam 7 hari

5.0

(1 ulasan)

2.0

@sarojsbp

I have Hands on experience in software development and in developing tools. I have good experience in C# web and windows application. I am fit for this work.

$140 USD dalam 7 hari