Perl script to export sql query to csv jobs

I'm looking for a seasoned AWS Data Engineer with over 8 years of experience to support me in handling data extraction and transformation tasks. Key Responsibilities: - Data Extraction: The engineer will be responsible for extracting structured data held in SQL databases. - Data Transformation: You will be required to transform the extracted data into a usable format for our analytics and reporting. Skills and Experience: - 8+ years of experience as an AWS Data Engineer. - Proficient in working with structured data, in particular, SQL databases. - Extensive experience in data transformation. - Expertise in AWS services, especially Amazon S3 and Glue. Your support will be essential in ensuring the smooth flow of our data processes. Please provide examples...

I'm looking for a skilled developer who can create a custom trading script in Pinescript on the TradingView platform. This script will be based on identifying and monitoring market trends. Key Project Details: - The script should be able to accurately identify a trend based on the definition of "higher highs and higher lows". - When a trend is identified, the script should take no immediate action but continue to monitor the market conditions. Ideal Skills and Experience: - Proficiency in Pine Script and experience with TradingView platform. - Strong understanding of technical analysis, particularly in the context of identifying trends. - Previous experience in developing trading scripts or bots is highly advantageous. - A ...

[Deadline Saturday 5 pm EST] Hello, I am trying to create some supervised models in Python based on this Kaggle data set I have started however struggling to finalize the code; Preliminary Data Exploration: Explore the data, and provide some basic summary statistics and two or three visualizations. Describe/show something interesting and/or surprising about the data. This exploration should not be exhaustive, just a highlight of a few interesting things about your data set. If you need to reduce the size of your data to fit now is the time to do that. Data Exploration: shall include a bulleted or numbered list of proposed specific data explorations you intend to carry out (include visualization). These insights are things that

Hi, I need a script that scrolls down page and clicks mail buttons then clicks next page then does the same. I think python maybe?

I need a skilled freelancer to install and configure Dolibarr for our company's productive site on our intranet. Here are the specifics: IA definition: (below you can see my own) - We need the inventory management, manufacturing, service contracts and human resources management features to be properly configured. - The system must be set up for 1-10 users to access on our intranet. Customizations and integrations: - We may require custom reports or dashboards, although the specifics for these are not yet entirely defined. - There may be other custom integrations needed as the project progresses. Ideal Skills and Experience: - Proficient in Dolibarr installation and configuration - Previous experience in setting up Dolibarr for small businesses - ...

I'm in need of someone with strong experience in PostgreSQL for some critical tasks. ...need of someone with strong experience in PostgreSQL for some critical tasks. - The ideal candidate should be well-versed in PostgreSQL, with a background in both database administration and development. - You must be able to handle complex issues that may arise with the database and be capable of performance tuning when necessary. - I expect you to understand the nuances of PostgreSQL and be able to provide solutions to potential problems with the database. - Any experience with data migration, query optimization and database design will be a plus. Please make sure to include your past work and experience with PostgreSQL in your application. Your ...

i have one php script which used to load in a few seconds now takes 4 minutes not sure why it suddenly lags need optimised - the mysql query hittin some bottleneck somewhere by looks of it

I kindly ask for payment that I did up to here: - Inspect the code and remove Invisible mode section on profile page for mobile and desktop theme - Enable/fix youtube video's sound for desktop version of script

I'm looking for an experienced full-stack developer to build a custom admin dashboard for a Flutter app backed by Firebase. The dashboard should have a clean, minimalist design and robust functionality to manage the platform. Core Features: - Firebase Integration - Comprehensive Data Visualization - Content Management (Articles, Quizzes, Categories) - Feedback Management - Notification System (In-App, Push) Other Key Features: - Secure Admin Authentication - User Management (Roles, Permissions) - Content Packaging & Distribution - Content Localization - Import & Export Functionality - Settings & Integrations - Security & Compliance - Performance Monitoring & Optimization The ideal candidate should have: - Proven experience developing adm...

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

I'm looking for a Python expert to help me create a new Python script for data analysis purposes. The primary goal of the script will be to analyze a dataset that I already possess. The script should be able to handle large amounts of data efficiently, allowing for insightful analysis and visualization. The key requirements include: - Writing new code from scratch - Prior experience in data analysis using Python - Proficiency in Python libraries such as Pandas, NumPy, and Matplotlib If you have a solid background in data analysis and Python, and are able to create efficient, clean, and well-documented code, I'd like to hear from you. Here are details- I have to create a simulation that will find the optimal s...

I have collected the dataset in CSV format and now require an expert to develop a multi-class logistic regression model for me. Key requirements: - The dataset is ready and available in CSV format which can be used for the model. - You should have expertise in developing logistic regression models for multi-class classification. - Proficiency with Python is a must as I prefer the model to be developed using this language. Technical Requirements: Proficiency in Python and familiarity with libraries such as NumPy, Pandas, Keras, and TensorFlow. Knowledge of statistical learning, logistic regression, and gradient ascent optimization. Ability to write clear and concise documentation and well-commented code.

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

Hello, I need fil a CSV with the Amazon categories in French

I'm looking for someone to integrate an existing machine learning model into a Discord bot. The bot should cater to three main functionalities - sending daily race predictions, responding to user queries about race outcomes, and providing real-time race updates. Key Requirements: - Integrate an existing machine learning model into a Discord bot - Implement a feature to send daily race predictions on a specific channel - Develop a query system that effectively responds to user queries about race outcomes - Enable the bot to provide real-time race updates Your Skills: - Proficiency in machine learning model integration with Discord bots - Experience in developing chatbots, particularly for Discord - Knowledge of horse racing and relate...

I need a Python script that can batch process text overlay onto images (jpg/png). All the images and all the text will be unique. Each set of text(s) (1-2 sentences) will have its own unique image. (one-to-one) I would like to have a CSV file containing all the unique sets of text. The script would reference a folder of images. The script needs to be able to handle 20-200 images. I would like to be able to change the font style, size, the position on the image, and to have the text be able to wrap to the next row on the image.

...Specifically, I'm unable to send messages. The automation is running on Windows and the script is written in Node.js. Key requirements: - Diagnose and fix the issue: The core problem lies in the inability to send messages. As such, the ideal candidate should have a strong understanding of OpenCV and related concepts, as well as experience with automation on WhatsApp. They should be able to quickly pinpoint the issue and implement the appropriate solution. - Windows proficiency: The automation is running on a Windows platform. The ideal candidate should be familiar with the quirks and intricacies of automation on this OS. - Node.js expertise: The script is written in Node.js. The freelancer should have comprehensive experience with this languag...

Please develop a Python script to retrieve restaurant data from Google Maps using the Maps/Places API. The script should specifically target restaurants that have a phone number but *without* a website. The inputs I need to enter are: - Location (latitude and longitude) - Search Radius (meters) - Restaurant Type (including catch all types in the "Food and Drink" category) Key Data to Retrieve, output in a .CSV: - Name - Address - Phone Number - Google Maps URL Ideal skillset: - Proficient in Python - Strong experience with Google Maps/Places API - Ability to deliver results promptly and efficiently - Attention to detail to ensure accurate data retrieval

create 10 spreads (20 pages), an A5 book or magazine for Porsche Develop full research about the topic and writing the content to design an interactive digital artwork. Tasks to be covered: Task 1: Research your selection and analyze all needed aspects. Also, Mood Board (your visual research) + Layout plan (Dividers and interactive buttons) as we discussed in the class. Task 2: Design a suitable layout for your selected topic. Use Table, margins, columns, master pages, and paragraph/character style. Task 3: Submit InDesign file (Packaged) and export an interactive digital file (PDF). Task 4: A Presentation on screen, that discusses the project’s concept and process.

I'm looking for a talented 2D animator who can create 3 engaging and entertaining videos, each lasting between 45-60 seconds. The primary goal of these videos is to captivate and entertain the audience. Key Responsibilities: - Develop 3 separate videos in a minimalist animation style - Ensure the videos are engaging and entertaining throughout - Incorporate the ready-made script seamlessly Ideal Freelancer: - Proven experience in 2D animation and motion graphics - Capable of creating entertaining and engaging content - Proficient in working with ready-made scripts - Prior experience with minimalist animation is a plus Brief Documents for 3 Video's Below: Video 1 - Annuity Payout Options: Video

create 10 spreads (20 pages), an A5 book or magazine for Porsche Develop full research about the topic and writing the content to design an interactive digital artwork. Tasks to be covered: Task 1: Research your selection and analyze all needed aspects. Also, Mood Board (your visual research) + Layout plan (Dividers and interactive buttons) as we discussed in the class. Task 2: Design a suitable layout for your selected topic. Use Table, margins, columns, master pages, and paragraph/character style. Task 3: Submit InDesign file (Packaged) and export an interactive digital file (PDF). Task 4: A Presentation on screen, that discusses the project’s concept and process.

I'm in need of a skilled and experienced developer that can assist me in automating several tas...need of a skilled and experienced developer that can assist me in automating several tasks, organizing files and data on Google Drive using Google App Script and Java programming language. Key Tasks: - Create scripts to automate Folders and files - Improve file organization and management on Google Drive - Develop custom solutions using Java Ideal Skills: - Proficient in Google App Script and Java - Strong background in automating tasks - Proven experience in organizing and managing files - Prior experience with Google Drive is a plus Your expertise and knowledge in these areas are crucial for the success of this project. Looking forward to collaborating wit...

Please Sign Up or Login to see details.

I need a skilled Web Scraping specialist to write code in Python (preferably) that scrapes a specific table from a website for me (Website: ). The table contains WNBA player statistics, The goal is to extract all columns of this table, which is approximately 7 columns and write it to a CSV file (in the same column format). I'm a beginner level coder, and noticed that the table was created with that looks like a Shiny App in R. (I'm not even sure if extracting the table is possible). If it was only possible to use R, then I could potentially work with that. Website: I would like the data to go from the year 2020 to current. Regular Season data. Key Requirements: - Scraping Tables on websites If you're

...monitor a MySQL database on my Windows system. The app should be able to perform the following functions: - **Monitoring MySQL Database**: The application should constantly monitor my MySQL database and detect when a new record is created. - **WYSIWYG Template Management**: There should be a feature that allows me to manage various WYSIWYG templates. These templates would be used to generate dynamic PDFs based on the new records in the database. - **PDF Generation**: Upon detecting a new record, the application should automatically generate a PDF based on a selected WYSIWYG template. Naming convention based on filed in processing record. Option Password added to pdf. I would like the application to be user-friendly and easy to navigate f...

We are in the middle of migrating Django to a new server. - Both servers run Ubuntu 20.04, postgres 12, python2.7 - The Django Project is already transferred over - Nginx has been configured - Postgresql has been setup Our struggle is to get the actual application up and running again. Your job will be to: - help to perform a clean export of the postgres database on old server - help to import the postgres database on the new server - ensure the Django application is coming back up smoothly The work will be done using shared tmate ssh sessions.

I need a VRBO scraper to extract property details, pricing, and availability. - The scraper should be built with Python and the output should be in CSV format. - The data points I need include property title, description, amenities, pricing, and availability. - The scraper should be able to handle multiple URLs at once. - The code should be well-structured and commented for easy maintenance. Ideal skills: - Proficiency in Python - Experience in web scraping - Understanding of VRBO website structure - Ability to handle and store data in CSV format

I need a web scraping professional to create a script to extract specific data from , a popular online marketplace for trading cards, please check attachement to get the idea. Key Requirements: - Scrapping: The primary task is to scrape the following information from the platform: - Card properties 1. Hero score for last 7 days 2. Hero rank for last 7 days 3. Stars 4. Rarity 5. Name 6. Quantity listed to purchase 7. Inflation data 8. Minted count - Buy prices List Price Last Price Order book (price and quantity see picture attached) - Bidding details bids book (bid and quantity see picture attached) - Twitter activity per card View Views+ Likes Likes+ Retweets Retweets+ Replies Replies+ Quotes Quotes+ Bookmarks Bookma...

...setting up a Python script that can scrape a popular review site. Key details to extract: - Review text - Star rating - Date of review - Reviewer name - Star-ratings for sub-categories - Review ID - Reviewed person - Reviewed product name The site does not use captchas, so it should be reasonably straightforward. All reviews for a given provider should be scraped. It would be good to have an option to start with the newest and stop at a certain date. The specific review site can be seen in the sample URL in the attached PDF. I can send further details in a private message including screenshots. Preferred frameworks would be Beautifoulsoup 4 / Scrapy if sufficient and Selenium otherwise. Please state which one you plan to use. Note: it should be p...

I have a PDF membership directory that was emailed to me. I need someone skilled in data extraction to help convert it into an easily readable CSV file. The ideal candidate should possess: - Proficiency in working with both PDF and CSV file formats. - Strong data extraction skills. - Attention to detail for data accuracy. Each member listed per row with the perinate contact information separated into its own cells ie: entity/last name/first name/address/ste#/city/state/zip/office ph/email/cell ph The task should be completed by 5/23/24.

Create a tradingview script that: Show a candle from green >red>green and vice versa but the condition that second candele cannot close lower or higher than prior third candele cannot close under previous open.

I'm looking for a skilled developer who can create a custom trading script in Pinescript on the TradingView platform. This script will be based on identifying and monitoring market trends. Key Project Details: - The script should be able to accurately identify a trend based on the definition of "higher highs and higher lows". - When a trend is identified, the script should take no immediate action but continue to monitor the market conditions. Ideal Skills and Experience: - Proficiency in Pine Script and experience with TradingView platform. - Strong understanding of technical analysis, particularly in the context of identifying trends. - Previous experience in developing trading scripts or bots is highly advantageous. - A ...

I came across a minor issue on my website on Digital ocean cloud server. Refer the below error information. I need someone who can fix me immediately in an hour. Error 500 PleskExceptionDatabase DB query failed: SQLSTATE[HY000] [2002] Connection refused

There are 89 simple phrases and the recording would take about 15 mins. the speakers need to be: - Native Italian speakers from Italy. - Age from 18-55. - Both professional voiceover or amateur Budget: $8 per speaker. We reserve the right to reject any recordings that do not meet our quality standards. (the pronunciation) Feel free to contact me if you are interested in this project. Best Regards Libby

...agriculture business that focuses on growing fruits and vegetables for both local and export markets. In need of a logo design that communicates the authenticity and sustainability of our products. Key points: - Logo Theme: It should reflect our business as an agriculture company. - Message: The logo needs to convey authenticity and sustainability. - Design: Simple yet effective, avoiding overly complex or ornate designs. - Color Scheme: Earthy, natural hues would work best. - Can incorporate an illustration of agriculture or farming Ideal Skills and Experience: - Experience in designing logos for agricultural or sustainability-focused brands. - Demonstrable portfolio of simple yet effective logo designs. - Ability to capture the essence of a brand through minim...

I am in need of a skilled professional who can develop a Rhino Grasshopper script for a pipe network. This script. Check attachment for specs. Ideal skills and experience for this project include: - Proficiency in Rhino and Grasshopper - Strong background in architecture and structural engineering - Experience in developing similar scripts. Please note that the specifics of the script are outlined in the document that will be provided upon engagement. I am looking for a professional who can deliver high quality work within the specified requirements.

A business-centric, data-oriented, and analytical mindset. Comprehensive knowledge of data science concepts and disciplines. Knowledge of enterprise information management processes and methodologies. Skills in database design, data security, and data lifecycle ...considerations. . Combinations of experience and education will be considered on a case-by-case basis. Experience in data warehousing and governance. Practical experience in enabling data usability, availability, and efficiency. Experience in data management, quality, metadata management, and modeling. Knowledge of database systems: MS SQL Server, Oracle, or another commercial RDBMS required, Snowflake, or other non-relational database desired. Knowledge of SQL. Experience with scripting languages, especially Python...

...for an expert in Microsoft Power Apps to develop a canvas screen for me. The screen will enable the gathering and insertion of information into a database. Requirements: - Incorporate text inputs, dropdown menus, and date fields for gathering information. - The preferred database language is Microsoft SQL Server but SharePoint can be used as an alternative. Additional Information: - You don't need to worry about any additional features or functionalities. The main goal is to develop a basic, yet effective form for data collection. Ideal candidates should have experience in: - Microsoft Power Apps development. - Integrating Power Apps with databases, specifically Microsoft SQL Server. You should be comfortable working independently and be a...

I'm looking to test database scraping on a website to extract names and potentially contact emails (if available). The data doesn't necessarily need to be organized or cleaned post-extraction. Ideal Skills: - Proficiency in web scraping tools - Understanding of database structures - Familiarity with handling contact information The data should be organized in an excel and csv based on the desired layout.

As a diligent user of Google Drive, I'm seeking a proficient developer who can create a program using Google App Script to arrange my Google Drive files in a hierarchical manner. Let's make searching and organization efficient and automated! the specific features I am looking for well be explained in private The ideal freelancer for this project would have extensive experience with Google App Script and an understanding of how Google Drive works. You should have created similar file management tools previously, and have a knack for creating user-friendly interfaces. Efficiency is key, as is the ability to work on a tight timeline. I look forward to working with a problem-solver who can make my file management efficient and hassle-free.

I'm looking for a skilled designer who can create a logo for my export business. The logo should reflect the nature of my business, which primarily deals with exporting agricultural products, specifically RICE. This is a crucial aspect of our business, so the logo must be able to emphasize that. Key Expectations: - Design a unique and professional logo. - Ensure the design reflects the nature of the business. - The logo should be versatile and suitable for a variety of uses, including online and print materials. Ideal Skills and Experience: - Proven experience in creating logos for businesses, particularly within the export sector. - Strong design skills, with a good understanding of branding and visual communication. - Ability to deliver high-quality, un...

scrape data from darty site and export it into excel file.

Based on a specific Management zone

I'm seeking an experienced data scientist to work on a project to integrate datasets from CSV files with different features, and feed them into various ML algorithms. The primary objective of this analysis will be to classify the data into different categories. The end goal is to determine the efficiency of the different ML algorithms used, which are decision tree, random forest, extra trees, and XGBoost. The perfect candidate for this project would be someone with a solid background in data science, particularly with experience in working with datasets from CSV files and implementing machine learning algorithms. The candidate should also be able to interpret and present results through visualizations such as charts and graphs.

...trends and any engaging life experiences. Show your versatility as a creator by transforming simple, everyday moments into captivating content. - Audience: The channel is specifically targeted at young adults aged 18-34. I'd love to see how you've previously delivered appealing content to this age group. Ideal Skills: - Video Editing: Skilled in video editing software like Adobe Premiere Pro or Final Cut Pro. Enhancing visual aesthetics and ensuring smooth transitions will be key. - Creative Writing: The ability to script engaging content that appeals to a young demographic. - Social Media Management: Hands-on experience in managing YouTube channels, understanding algorithms and analytics. If you have previous experience in vlogging ...

I'm seeking a highly skilled Power BI professional to assist with creating interactive dashboards and generating data visualizations. The selected expert will be expected to work with data from both Excel spreadsheets and SQL databases, so experience with these sources is crucial. I will be looking for an advanced level of expertise, as the job will involve complex data modeling and designing sophisticated, interactive visual reports. A strong understanding of data analysis and visualization techniques is essential. Key responsibilities and qualifications include: - Creating interactive dashboards - Generating data visualizations - Working with data from Excel spreadsheets and SQL databases - Demonstrable advanced level of Power BI experience - Advanced ...

I need a professional content creator skilled in human development to provide me with 30 video scripts and ideas for my business centered on getting rid of old block how nervous system control you, personal growth, overcoming fears, and building self-confidence. Each script should be educational and informative, while maintaining a concise length of 1-3 minutes. Key Requirements: - A solid understanding of human development, personal growth, and related topics - Proven experience in creating concise and engaging video scripts - Ability to convey complex information in an easy-to-understand manner - Strong writing skills with a focus on educational content - Previous experience with similar projects is highly preferred Your work will play a crucial role in hel...

I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium...

I'm looking for a Unix shell scripting expert to help me with my project. Here's what's required: - Automating file transfers: I need a script that can download specific file types from a directory on my server and then upload them to an SFTP server. - Handling specific file types: The script needs to be able to recognize and transfer only files of specific types, rather than all files in the directory. Ideal skills and experience: - Proficiency in Unix shell scripting - Experience with SFTP - Expertise in handling specific file types in scripts - Familiarity with file transfer automation - Good communication and problem-solving skills If you feel you have the required skills and experience, please reach out. Thank you!

...this is all to be done on a new Linux STAGING ONLY server. 1) Linux staging server setup -> deploy our existing project to a new VPS using gitlab 2) Woocommerce -> continue long term development work on our existing custom plugin. Transfer the existing production woocommerce to this staging server. 3) ongoing long term development of our CRM app Other components of our stack which are a HUGE ADDED BENEFIT if you can work on them -> .NET ASP, WEB API + MS SQL DETAILS HERE -> PRIORITY IS TO HAVE A DEVELOPER ON OUR TEAM (LONG TERM) THAT CAN FOR NOW ALSO WORK WEEKENDS AS WE HAVE SEVERAL EMERGENCIES TO FINISH URGENTLY. Someone who can efficiently manage Linux VPS and efficiently use GITLAB is critical. Initially we need par...