SQL Queries in Python

My website is a big data analytics tool, scanning over 100 Million lines of data for every query.

Now I want you to refine my search by adding further SQL commands.

The search is written in Python and based on Elastic Search.

The website is built on Symfony.


1. add premade navigation bar and link content

at page bottom, fixed, z-index above all website content link content of search bar

2. add pagination

10 search results per page. Enough pages to show all results. “<” and “>” jump two pages.

3. revise search process

Country Selection

If a country is selected, only show search results of shipments which list that country in

the column “Country”. If USA is selected, show all search results.

words from multiple columns

When searching for multiple words, like for example: “the north face” + “tent”, show all search results that have all words in the columns “Consignee Name”, “Shipper Name” and “Product Desc”. Allow the words to be found in different columns. In the example above “the north face” could be found in “Consignee Name”, and “tent” in “Product Desc”.

4. revise website

delete previous search field. Scale down the height of the top navigation’s background to just underlay the links.

Skills: Elasticsearch, Python, SQL, Symfony PHP

See more: python 3 sql, python sql pandas, python sql server query, python database, python sql library, python database tutorial, run sql in python, python sql select, Optimize 2 SQL queries to avoid nested select statements, C, C++, Android, Python, machine learning, data analytics, linux, device drivers, website data extraction tool, http slanso com index php controller authentication&back my account&idlang 2, website data analytics, python script automate data download website, python script automate data entry website, website data python script, sql server scrape website data, python script retrieving website data, python script retrieve data website, delimiter sql queries python

About the Employer:
( 1 review ) Guangzhou, China

Project ID: #17327569

16 freelancers are bidding on average $158 for this job

$155 USD in 3 days
(26 Reviews)

Hi there..... Warm Greetings We came along with your request for SQL Queries in Python and we reviewed your project description. We'd like to help you with confidence and satisfying results... We have professi More

$250 USD in 3 days
(17 Reviews)
$100 USD in 3 days
(32 Reviews)

Dear Sir. I am Adam Poh. Nice to meet you. I am python developer. I had developed several websites by using python Django. Database query is basic skill for web developer. Please send me message. And check this yo More

$300 USD in 3 days
(23 Reviews)
$155 USD in 3 days
(10 Reviews)

Hello Having experience of python, I can do what you want. Python is my primary programming language. Let us discuss details in chat.

$150 USD in 3 days
(35 Reviews)

Hello. I have read your project description and I have enough experience to complete your project. I am a python expert and I have full experience in developing elastic search projects. I think we can discuss more d More

$100 USD in 3 days
(5 Reviews)

Hello! I am a python developer. I looked at your project and it seems interesting. I have all necessary skills required for this project. Ping me to discuss in detail.

$125 USD in 2 days
(15 Reviews)
$150 USD in 3 days
(9 Reviews)
$155 USD in 3 days
(3 Reviews)
$166 USD in 2 days
(5 Reviews)
$50 USD in 1 day
(1 Review)

I will rebuild your complete website with end to end development and integrating everything that you want for your website business model with all the features and functionalities that you mentioned above. More

$250 USD in 20 days
(1 Review)

House object detection for an Australian client -Traffic light detection for a self-driving car startup -Logo detection in a video stream for a Israeli brand endorsement company [login to view URL] - classification for different f More

$155 USD in 3 days
(0 Reviews)

New but the best.

$88 USD in 3 days
(0 Reviews)
$177 USD in 4 days
(0 Reviews)