Concluído

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

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.

Habilidades: PHP, Programação C#, JSON, MySQL, Desenvolvimento de Software

Veja mais: filtering an array of json objects by multiple properties, filter json object by key, json filter with multiple values, filter data from json object in jquery, how to filter data from json file, json filter online, json filter, json filter example javascript, need textbook solution, jquery remote json file, need pull data csv delimited text file, extjs json file, extjs datagrid blank local json file, jquery select load json file, jquery json file, create json file html, make json file, saving html data json file, solution counting words text file finding frequency write test mips assembly language program, create table json file

Acerca do Empregador:
( 36 comentários ) Sabrevois, Canada

ID do Projeto: #25160370

Concedido a:

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 t Mais

$200 USD em 7 dias
(38 Comentários)
5.6

14 freelancers estão ofertando em média $182 para esse trabalho

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 in 3 dias
(52 Comentários)
6.2
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 Mais

$500 USD in 7 dias
(10 Comentários)
5.4
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 in 7 dias
(2 Comentários)
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 yo Mais

$140 USD in 3 dias
(32 Comentários)
5.1
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 in 3 dias
(12 Comentários)
5.0
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 in 3 dias
(11 Comentários)
3.7
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, Mais

$120 USD in 7 dias
(3 Comentários)
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 in 7 dias
(2 Comentários)
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 resu Mais

$100 USD in 7 dias
(1 Comentário)
1.9
neosoft11

Hello, I've just gone through job description carefully and am interested. I have rich experience in these fields. I am working in these fields for years, so I have enough confidence with these kinds of projects. If yo Mais

$170 USD in 7 dias
(1 Comentário)
1.7
ak27freelancer

Hello, I am pleasure with your job for Need a tool or solution to filtering a 22GB JSON file. Thank you for the job posting. It’s a pleasure to meet you. I’d really like to work with you on this one if possible! I do h Mais

$140 USD in 7 dias
(0 Comentários)
0.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 in 7 dias
(0 Comentários)
0.0
PKonstiantyn

I have experienced in Python, building Machine Learning models, Deep learning for computer vision and Natural language processing are some of my strong suites with a PhD in AI/ML. Image processing, Object detection and Mais

$200 USD in 2 dias
(1 Comentário)
0.0