Python script to insert data into postgresql jobs

...skilled freelancer to create a series of short ebooks/scripts about artificial intelligence. Below are the project details: Content Scope: The series should consist of 15 scripts, covering topics from Beginner to Medium levels. We make no books for AI-experts. Pages: 15-25 per script You can use ChatGPT for this Writing Guidelines: You can utilize ChatGPT or similar AI tools to assist in writing the content. Ensure all content is original and not copied from other books to comply with copyright laws. Write in a conversational style, as the scripts will be converted into audiobooks. Free visual graphics are welcome but not mandatory. If you use images, ensure they are properly licensed and provide the license information below the image and again...

use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days you simulate input data -> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states randomly 30 to 170 transactions per day for given product for usual price randomly 200 to 600 transactions per day for given product for promotion random dates and prices reduction for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product...

I'm looking for a skilled Laravel developer with prior experience in MLM and HYIP systems, who can make the following modifications to my existing script. Key Responsibilities: - Identify and resolve bugs within the script to ensure smooth operation. - Implement appropriate PHP conditions to update users in the database. Ideal Skills: - Expertise in Laravel framework - Previous experience with MLM and HYIP systems - Proficient in PHP and database management - Strong understanding of CRUD operations, authentication, and API integration in Laravel Please note, these modifications will require understanding of the existing codebase, so experience with similar scripts will be a definite plus.

I'm in need of a skilled AI developer to create an AI agent capable of handling product information and answering human chat requests based on a set of data from XLS and PDF files. The agent will be multilingual, starting with both English and Hebrew documents. Key Goals: - Provide product information: The AI agent should be able to efficiently fetch product descriptions data prices etc from the provided XLS and PDF files. - Generate automated responses: The agent should be capable of generating automated responses based on the product information retrieved and a give set of decision terr rules. Platform Compatibility: - The AI agent should be compatible with both web and mobile platforms. Programming Language: - While I have no specific preferences for...

...Storybook into Word Document Description: We are seeking a skilled copywriter to transcribe a storybook into a Word document. The job involves typing out the entire content of a storybook into a digital format. The storybook is approximately 100 pages long and contains a mix of text and illustrations. Responsibilities: - Type out the entire content of the storybook into a Word document. - Ensure accurate transcription of text, including proper formatting and punctuation. - Maintain consistency with the original text and illustrations. - Complete the task within the specified deadline of 1 day. Requirements: - Proficiency in English language and grammar. - Excellent typing speed and accuracy. - Experience in copywriting or transcription preferred. - ...

Active Directory Expert to create a Python script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, AD RMS (Rights management Services) group policy GPO etc. and export to a MS Excel File. More information attached.

I have a project where I need assistance with a few specific aspects of deploying node.js. These include: - Connecting to a PostgreSQL database that is currently partially set up, - Integrating with Sequelize, specifically addressing problems with model relationships, - Establishing a connection to AWS. This will be an hourly consultation, so I'm in need of a freelancer who is highly skilled in node.js deployment, PostgreSQL database set up, Sequelize integration, and AWS connections.

I'm looking for a machine learning expert to create a sentiment classification model for customer reviews. The main objective of this project is to classify customer reviews into one of three categories: Positive, Negative, or Neutral. The sentiment classification model should be able to accurately and reliably analyze the sentiment of a given customer review. Key requirements include: - Data Source: The data to be analyzed will be sourced exclusively from customer reviews. - Sentiment Detail: The model should identify and categorize the sentiment of reviews into Positive, Negative, or Neutral. Ideally, you should have: - Proven experience in machine learning, particularly in sentiment analysis - A strong understanding of nat...

...developer to create a Windows-based low level keyboard emulator primarily for gaming purposes. Key Requirements: - OS Compatibility: The emulator should work on Windows systems only. - Emulation Focus: The main target of this project is to mimic keyboard inputs for gaming applications. Ideal Skills and Experience: - Proficient in Windows application development. - Knowledge in gaming input emulation. - Strong understanding of keyboard input simulation. - Experienced in backend applications. This is a unique project that requires a developer with a good understanding of both Windows systems and gaming input. A passion for gaming would be an advantage in understanding the user requirements. "Note: There is a firewall in the game, and I DO NOT want the person taking...

I am looking for someone to Add Products to our laced store.

I'm in need of an all-ro...an all-round developer who has strong experience in both Python and PHP, specifically for the creation of an e-commerce website. The desired professional should be well-versed in crafting custom web solutions as well as knowledgeable in leveraging the WordPress CMS beneficially. Skills and Experience Required: - Demonstrated expertise in Python and PHP web development. - Proven experience in developing successful e-commerce websites. - Proficiency with WordPress CMS. - Understanding of e-commerce website security essentials. - Articulate in communicating project progress and potential hurdles. Freelancers who can showcase previous work on similar projects will be given priority. I look forward to your enticing bids and am eager t...

...engineer or data scientist to create an automaton for recognising handwritten digits specifically within mathematical problems. Responsibilities: - Develop a machine learning algorithm capable of recognising handwritten digits - The primary focus will be on mathematical problems - Ensure accuracy and adaptability to various handwriting styles - Configure the algorithm to output recognized digits as digital numbers Ideal skills & experience: - Proficiency in machine learning algorithms and principles - Extensive experience with handwriting recognition software - Demonstrate capabilities in Python, TensorFlow or similar platforms - Have a deep understanding of Optical Character Recognition (OCR) - Familiarity with mathematical problems and their ...

I need a skilled Pine Script coder for TradingView to help with extracting code from a restricted invite-only script. This script is accessible to me but is otherwise restricted. Key Responsibilities: - Extract the code from the restricted script - Perform major modifications as needed (e.g., changing algorithm, adding/removing features) Ideal Skills and Experience: - Strong experience in Pine Script coding for TradingView - Proven track record of extracting and modifying code from restricted or invite-only scripts - Ability to make significant changes to a given algorithm, indicator or strategy

...Django/ Java Script with Bootstrap expert who can assist with the layout and design of my website atplands.com. The primary goal of this project is to update the site's visual appearance. My website: Reference downloadable Theme code: Key tasks include: - Reviewing the current website and providing recommendations for improvements - Collaborating with the team to create a new, fresh look for the site - Ensuring the new design is functional and user-friendly Ideal skills for this project include: - Strong experience with Django/ Java Script with Bootstrap - Proven track record of working on front-end development using JavaScript/Bootstrap - A good eye for design and layout - Ability to understand and implement JavaScript to integrate

...SQL teach me how to free install on my local windows 11 you have 2 days to do you simulate input data -> transactions data just ideas for python data simulation *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years suggest your columns also more needed columns will be provided simulate tables with store transactions take to account - promotions -store location -state -usa holydays simulate lookup tables for 1 promotion 2 store locations 3 prices changes each 3 months etc data simulation may be done in python and then upload to SQL DB (but better in SQL) you provide both sql and python code for both simulation

I need an expert in Python for maintenance tasks on some existing code. Key Tasks: - **Bug Fixing:** This code has some bugs that need to be identified and fixed to ensure its proper functioning. - **Code Optimization:** Your expertise is crucial to streamline and optimize the performance of the existing code. Ideal Candidate: - Proficient in Python - Experienced in code maintenance - Skilled in bug fixing and code optimization.

I'm in need of a skilled developer who can create a Telegram bot for scraping user data and automatically inviting them to join a specific channel Key Requirements: - Ability to work with multiple telegram accounts (multithreaded). - The bot should be able to scrape usernames and phone numbers from specific Telegram groups or channels already added into relevant accounts. - The scraped data should be used to automatically send invites to join a specified group. Ideal Skills & Experience: - Proficiency in Java or Python and the Telegram API for bot development. - Experience with web scraping and data extraction. - Proven ability in creating Telegram bots for automatic interaction. Please note that the bot w...

What we have -------------------------- 1: Excel or CSV file. containing addresses to post letters 2: Letter Quality ( Paper weight, Sizes, Cost per letter etc configuration in JSON array) What we need -------------------- - Standalone PHP Script where we will be able to select an item from provided JSON. - Through DHL API we will validate the provided addresses(in the form of exel or csv) if each individual address is valid - or we should be able to select the areas of over choice over google map is shown in the provided video - this funcationaly is also provided over DHL api I think. and there demographic filters can also be applied which are provided be DHL api also shown in the video Please apply only if you the the required experience. these links may h...

...professional who can convert both scanned documents and photos into simple data in Excel format (language is not in English workable when one can use translate and understand the few terms that are there). The ideal candidate will have the following skills and experience: - Proficient with MS office - Expert in handling MS Excel - Ability to follow a specific Excel template provided - Attention to detail to ensure accurate data entry ***The task is very simple and just requires attention to detail. I need mainly 4 Data Rows: 1. Date 2. Payor/Payee 3. Amount 4. Short Description of Transaction (if given in the doc) Please message me to talk about the project and the realistic bid price per Job. Your responsibility wo...

I'm searching for an experienced Python developer to handle data collection and processing in the financial sector. Your tasks will consist of two core elements: - Data Collection: Obtaining data from diverse financial sources, including stock market data, cryptocurrency data, and financial news data. - Data Processing: Once collected, you'll perform various calculations and analyses, including statistical analysis, trend analysis, and calculations with a focus on historical data. Familiarity with these tasks and the financial sector is crucial to delivering the results needed. Your expertise in Python and financial data processing will contribute significantly to the project's...

I have a prompt to 3D generation source code written in Python. Unfortunately, the current code is riddled with bugs, specifically syntax errors, runtime errors, and logic errors. I'm in need of a Python expert who can help me debug and fix these issues. Key responsibilities: - Execute a thorough debugging process to locate and correct syntax, runtime, and logic errors. - Ensure the model is running efficiently and effectively. Ideal skills and experience for this job: - Proficiency in Python with a focus on debugging. - Prior experience working with 3D models is a plus. - Good understanding of software development and bug fixing processes.

I need someone to convert my current trading bot that was written in Node.js into Python, specifically version 3.10. The bot, which uses Puppeteer for browser automation on the Quotex platform, needs to be programmed to use Selenium in the Python version. Key features to incorporate into the new Python bot include: - Real-time data monitoring - Regular trading automation - Custom trading strategies Freelancers should have an extensive understanding of Python and Selenium, along with experience in trading automation. The end goal is to have a Python version of the trading bot that works flawlessly round the clock without any hitches, preserving all the functional features of the original Node.js ve...

I'm seeking a skilled embedded software developer who's proficient in C, C++ and Python to create a custom solution for a microcontroller-based system. The primary focus of this project is the successful implementation of various communication protocols on the embedded software. Key Responsibilities: - Develop an embedded software running on a microcontroller - Implementation of communication protocols within the software - Testing and debugging of the software for optimum performance Ideal Skills and Experience: - Proficient in C, C++, and Python - Previous experience in embedded software development - Familiarity with microcontroller systems - Strong understanding of various communication protocols Please include any relevant past projects or experience...

Seeking ML expert (MSc/PhD) to implement hybrid DCN model for Bitcoin price prediction using Python. Tasks: data collection/preprocessing, EDA, model training/evaluation, results analysis & report writing. Ideal candidate has experience in financial forecasting & cryptos.

I'm seeking a Python developer experienced in Selenium to create an automation bot. The primary aim of this project is to automate repetitive tasks. https://pump. fun/6rEPojp1CJxgKUts64hrKpvNRFUYd3JvxE5KKYXgCkjj this is script description: i will provide list of privatekey and list of text /image post. bot will post reply you need to install phantom wallet extension connect wallet with this site and then post reply Key tasks include: - Developing a Python Selenium bot that can perform specific, pre-defined tasks - Ensuring the bot is easy to use for personal use Ideal candidates will have: - Proficient in Python and Selenium - Experience in developing automation bots - Can work with little supervision and have excellent...

I require an individual proficient in VB macro script for Mach3. This project entails recreating a Mach4 script that particularly focuses on: - Arc motion control - Tool length calculation from spindle holder to tool tip - B/C axis management and position zeroing I have mach4 script that need to be rewriten to mach3 VB language, I have also a video how it works in mach4 fo refernece. You should be able to implement these specifications based on available documentation. Please remember that the recreated script should maintain as much fidelity to the original Mach4 script as possible. Ideal skills and experiences for the job include: - Familiarity with Mach3 and Mach4 CNC software - Expertise in creating VB macro sc...

As an investor seeking to streamline my algorithmic trading operations, I am in need of an able Python Developer who specializes in automation tasks. This role requires an individual with: - Mastery of Python and experience with automation tasks, most especially within the investment and stock market scenario. - Skilled and knowledgeable in stock market terminology with experience in use of Websockets for API integration Suitable candidates are expected to have good communication skills to effectively understand and implement required changes in a timely fashion. Help me maximize my trading potential with your Python expertise!

I'm looking for a Python developer who can upgrade my current mass mailing script. The goal is to enhance its overall performance, improve the user interface, and add email delivery tracking. Key requirements: - **Performance Improvement**: The upgraded script should handle mass mailing more efficiently, ensuring that emails are sent promptly and don't get caught in spam filters. - **User Interface Enhancement**: A more user-friendly interface with clear controls and options is essential for effective use. - **Email Delivery Tracking**: I need to be able to track email delivery statuses for each recipient. In addition, the primary goal of this upgrade is to improve the inboxing rate. While the current script is functional...

As the client, I'm in search of a skilled scriptwriter to craft a personal biography with a focus on the thematic narration of my inner journey and self-discovery. • Biography Type: The script should be based around a personal biography, concentrating on my personal experiences rather than professional accomplishments. This biography will serve as a means to convey my deeper self-exploration and development. • Storytelling Approach: I favor a thematic over chronological narration. The structure of the biography should play around themes derived from my inner journey and the continuous path of self-discovery I have undergone. The storytelling should effectively weave the themes from my life experiences throughout the script instead of a time-base...

I'm seeking a talented developer to construct a robust DDEX music distribution system. This platform will serve as a key component of my radio station's operations. We're looking for a developer with experience on building a DDEX distribution system where the user can upload the tracks and albums, images to distribute on different dsp sites like Spotify, Beatport, Apple Music, etc and receive music from our industry partners. With functionalities where the user can upload any format of track file like mp3, wav, flac so that it can be encoded into different formats and can be distributed to different dsp sites depending upon required formats. The administrator can upload the royalty files in different formats like xls, csv, txt. provided by dsp si...

...Storybook into Word Document Description: We are seeking a skilled copywriter to transcribe a storybook into a Word document. The job involves typing out the entire content of a storybook into a digital format. The storybook is approximately 100 pages long and contains a mix of text and illustrations. Responsibilities: - Type out the entire content of the storybook into a Word document. - Ensure accurate transcription of text, including proper formatting and punctuation. - Maintain consistency with the original text and illustrations. - Complete the task within the specified deadline of 1 day. Requirements: - Proficiency in English language and grammar. - Excellent typing speed and accuracy. - Experience in copywriting or transcription preferred. - ...

I'm looking for a Python expert to evaluate the CI checks and implement a solution to effectively detect configuration drift. The primary goal of this task is to establish a system that can automatically alert via email or messaging platforms whenever a drift is detected. Key Requirements: - Strong proficiency in Python and extensive experience in its usage - Strong knowledge of atlantis and terraform - Solid understanding of CI checks - Prior experience with monitoring and fixing configuration drift - Ability to configure alerts Your role will be crucial in ensuring that our CI check is enhanced to identify any drift and alert the team in real-time. Please provide your proposal outlining your approach, relevant experience, and expect...

I'm seeking a proficient data analyst to decode my online shopping platform's sales data. The primary task is to accurately identify prevailing sales trends. Your role will encompass: - Cleaning and preparing raw sales data from the online shopping platform - Utilizing advanced statistical methods to analyze the data - Identifying significant sales trends - Providing a detailed report on the findings Ideal Skills: - Proven experience in data analytics, particularly sales data - Proficiency in statistical software like Python, R or SAS - Ability to interpret complex data and communicate findings effectively - Prior experience working with online shopping platform data will be advantageous....

I am in need of an experienced Algo / Python developer with a strong background & deep understanding of algorithm construction. As part of this project, you’ll be responsible for: Algo for Range breakout :-- - Developing algo in python for Range Breakout strategy - Test it & implement for the demat account in brokers- Upstock, Alice Blue, Dhan & 5paisa Ideal skills for this role include: - Extensive experience with Python specifically in the areas of automation and algorithm development - Familiarity with stock market - Strong ability to run effective algorithms Your role in this task is more tilted towards the developmental side, with the creation of an algorithm being the primary focus. You are expected to apply your Python...

Hi there! I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a...

My Python script is intended to scrape specific Telegram groups, but it's not functioning as expected. I need a developer to address these issues, described below. - **Issue Description**: The script is crashing when scraping certain Telegram groups, which is likely due to the fact that it's not respecting selections. The error presented is “ AttributeError: 'MessageMediaWebPage' object has no attribute 'document'” I can provide the script if you want to check how it’s working. I am open to a whole new script being made. So long as it functions in a similar way. If not familiar you can view telethon api - **Expected Behavior**: The scraping script is supposed ...

I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.

I need a script that can scrape the Google Play store specific data from list of apps in the search result url of any keyword. Need data in Excel spreadsheet. Eg : if i search cat in playstore, i need the below mentioned details of first 100 apps shown in the search result. Key Project Details: - I require the script to scrape app names, descriptions, emails, download counts, and URL of the app. - The scraped data should be compiled into an Excel spreadsheet format for my review and analysis. - deploy the script into my server The Ideal Freelancer: - Proficient in web scraping tools and techniques - Experience working with Google Play store data - Competent in automating data extraction and processing - Abili...

We are seeking a skilled and motivated Cold Calling Specialist to support our digital marketing agency located in Canada, Kelowna. As a Cold Calling Specialist, your main responsibility will be following a script and calling businesses on Google Maps to get them to book an appointment with me. You will be provided with a list of leads on the goHighLevel CRM, and your task will be to reach out to these prospects via phone calls to introduce our services and secure appointments for our sales team. Skills needed: - Excellent communication skills - Proficient in cold-calling techniques - Fluent in English and Above - Able to work 30 hours minimum per week. - Familiarity with digital marketing services(Preferred but not required) - Book ...

Functionality: Data Collection: Retrieve historical stock data (price and volume) for a given set of stocks from a reliable financial data provider (e.g., Yahoo Finance, Alpha Vantage). Store the data in a suitable format (e.g., CSV files or a database). Data Preprocessing: Clean and preprocess the collected data, handling missing values and ensuring consistent formatting. Calculate necessary technical indicators, such as moving averages (e.g., 50-day, 200-day), Relative Strength Index (RSI), and trading volume. Technical Analysis: Implement functions to identify bullish signals based on technical indicators, such as: Moving Average Crossovers: Detect when a shorter-term moving average crosses above a longer-term moving average (e.g...

I'm looking for a skilled developer to duplicate the design and functionality of a website from TypeScript, JavaScript, HTML, and CSS to a Python-based system. The website currently allows users to input a URL for evaluation on its ACT and WCAG compliance. Once evaluated, it highlights any errors and provides recommendations for improvement. The source code is provided. Key Requirements: - Recreate user input URL evaluation - ACT and WCAG compliance checking - Error highlighting - Recommendation provision Design Changes: - Redesign of the website's layout - Improvements to the user interface Design Preferences: - Clean and minimalist design - Modern and trendy elements The source code is available for reference. Ideal candidates should have ...

...a medium complexity Pine Script that I'm currently using for backtesting on TradingView. I would like to convert this script into Python so that I can run backtests on my local machine. This Python script should produce the same results as the Pine script on TradingView, but handle different data resolutions (1hr to 1Day data). Key Requirements: - Convert a Pine Script into Python. - Ensure the output of the Python script matches the results produced by the Pine Script on TradingView. - The Python script should be able to handle different data resolutions from 1hr to 1Day. Ideal Skills and Experience: - Prior experience in backt...

We are seeking a talented and experienced UI/UX designer to help us seamlessly integrate our brand identity into a pre-existing website template we have purchased. This project involves implementing our brand colors, fonts, and visual elements to create a cohesive and compelling design. Project Overview: • Objective: To incorporate our brand identity into an existing website template with minimal changes, ensuring a simple and efficient development process. • Scope: The project will include updating page colors, fonts, and images to reflect our brand. The template will remain largely unchanged to maintain development simplicity. • Deliverables: A visually appealing website that aligns with our brand identity, using both vecto...

...our design concepts to life, creating a seamless and engaging front end for both web and mobile platforms. Must be developed using Phaser or Construct. Then I have this basic UI that also needs to be connected. We have an API/Backend developed already. The developer needs to be able to connect it. **Project Scope:** - Develop the front-end architecture for our platform, optimized for both web and mobile devices. - Ensure integration of visual content with live API connections for real-time data visualization. - Collaborate closely with our UX/UI designers to implement the visual and interaction design. - Conduct thorough testing across different platforms to ensure functionality and responsiveness. - Maintain regular comm...

A project is to find a better script or an idea to overcome ozforensics. Facial LivenessDetection Biometric verification without the presence of the person concerned

I'm seeking an entry-level Python developer to help create a new application. Key Responsibilities: - Developing the backend of the application with Python - Ensuring the application is robust and scalable Ideal candidate: - Proficient in Python; prior experience with web development is a plus - Ability to work efficiently as part of a team - Open to learning and growing in the role - Familiarity with HTML and HTTP concepts.

I'm seeking a Python expert to assist me with a data analysis project. Specifically, I need to: - Analyze financial data: The project involves interpreting and analyzing financial statistics and metrics. Experience in financial analysis is preferred. - Present results via annotated code: The deliverable should be the Python code used for the analysis, with comments and annotations explaining each step. This will help me understand the process and replicate it in the future. The ideal freelancer for this project would be skilled in Python programming, have experience with financial data analysis, and a strong ability to communicate technical concepts in code.

...skilled video creator to produce one mixed media promotional videos for my learning platform. The ideal candidate will be able to handle both animated and live-action elements seamlessly, including script writing. Actually what I wanted is to show a real person using my platform https://ooro.com.au. However, a 2D Animation with voiceover would be acceptable as long as rest of the requirements are met. Platform is designed so anyone with a skill or talent can register as a mentor. This includes actual teachers. And then if someone wants help with something they are learning, they can search for a mentor, who will use video call on the platform to engage with them. As an example, trying to imagine a video where people are getting assistance...

I'm in need of a smart and efficient developer to create a binary trading telegram robot. This robot should offer the following functionalities: - Signal Generation: The robot should be designed to generate both buy and sell signals for trading on PocketOption and OlympTrade platforms. The signals should be accurate, timely and should help in maximizing profits. - Delivery Mechanism: The signals should be delivered directly to the users via Telegram. The delivery needs to be prompt and reliable to ensure users can act swiftly on the signals provided. Ideal Candidate: - Proficient in creating telegram bots - Prior experience in binary options trading - Familiarity with PocketOption and OlympTrade platforms - Ability to deliver accurate and t...

We are seeking a skilled developer or development team to create a comprehensive web crawler system. This system should scrape, structure, and update information from web pages, handle large projects, and be accessible via a powerful API. The system should offer user-friendly features for both individuals and businesses and include flexible user management for both customers and employees. Project Requirements 1. Web Crawling and Data Extraction -Develop a system capable of scraping entire websites and extracting data from each page. -The system should divide the scraped information into sections to facilitate easy reading and understanding. -For e-commerce sites, the system should identify and structure the following information: --Product category (inc...