Data cleaning using sql jobs

... Key Functions: - Extract data from a relational database via SQL queries. - The ability to process and analyze reviews from different platforms such as blogs, social media, and online stores. - Generate a coherent 300-word summary from a multitude of reviews. Required Skills and Experience: - Expert level understanding of Python programming. - Knowledge and experience in SQL querying is a necessity. - Experience with Natural Language Processing for summarization. - Familiarity in dealing with relational databases. - Prior experience with text summarization or related projects is a definite advantage. The task is not only to code but also to gain understanding of reviews and to generate a meaningful summary. So, anyone who bidded should be proficient in data...

I'm looking for a skilled data analyst who can help me with a project that involves identifying patterns in customer behavior data. Key Requirements: - Proficiency in Python for data analysis - Extensive experience working with customer behavior data - Ability to create and present insights using visual charts Tasks Involved: - Importing and cleaning the provided customer behavior data - Applying appropriate data analysis techniques to uncover patterns(classification problem) - Presenting the findings through visually engaging charts The ideal candidate would have a strong background in data analysis and visualization techniques, especially in the context of customer behavior data. Experience in using Pyt...

Hello! I need you to write 1 article for my Amazon client and post them on relevant news platforms. IMPORTANT**Please provide me with "the estimated duration of the project", and "examples of your past work",and "how many platforms will yo...articles to multiple USA pet care platforms. we can discuss and adjust the platform if need a report detailing which news platforms you posted to and which performed the best. us to quote your article for use on our social media,website and Amazon posts. if you meet those requirements please leave the information i need, Thank you. article: Presenting the best method for cleaning your dog or cat's teeth, eliminating the need for brushing fights. Product Link: [] Post on: Pet care, pet blogs, news platforms.

Description: We are seeking talented animators to create a series of 3D animated videos, each 3 minutes in length, aimed at training hospital cleaning staff on handling infectious diseases. The goal is to produce engaging, educational content that demonstrates proper cleaning techniques and protocols in a hospital setting to prevent the spread of infections. The videos should be visually appealing, technically accurate, and easy to understand for a diverse audience. Requirements: Proven experience in 3D animation and storytelling. Ability to translate technical medical and cleaning procedures into clear, visual formats. Experience in creating training or educational videos, preferably in the healthcare sector. Deliverables: Three 3-minute 3D animated videos. Storyb...

I'm in need of an expert to set up SQL Server 2019 on a Windows-based virtual machine. The system will be used to support website and desktop applications. Key Responsibilities: - Configuration of SQL Server 2019 on a Windows virtual machine - Ensuring secure and optimal performance of the system - Testing the setup to confirm seamless connectivity with website and desktop apps Ideal Skills: - Extensive experience in managing SQL Server 2019 - Expertise in Windows OS and virtual machines - Should have strong troubleshooting skills on SQL server - Familiarity with website and desktop app integrations.

Excited to work with an experienced ASP.Net webforms developer, who will bring their skills to facilitate the Database integration aspect of our project. Key Responsibilities: - Integrate SQL Server with our existing ASP.Net project. - Create smooth and efficient functionality. - Ensure system robustness and efficiency. Skills and Experience: - Strong proficiency with ASP.Net Webforms. - Knowledge and hands-on experience working with SQL Server. - Excellent troubleshooting capabilities. It is not necessary for this project to migrate data from an existing database to SQL Server. However, the capability to do so may be beneficial in the future. If you are an experienced developer with the aforementioned skills, I would love to have you on board for this p...

I'm seeking an experienced Python developer to scrape a specific website and extract text data for the purpose of analysis. Your role will be the following: - Scrapping the text data from the specified website. - Cleaning the data to prepare it for analysis. High data quality is crucial so attention to detail is necessary. Ideal candidate would have proven experience in Python, data extraction, and data cleaning. Familiarity with data analysis will be beneficial.

I need a professional to clean my text data. The primary goal is to standardize the formatting of the data. - Your main task will be to format the text data in a consistent and uniform way, ensuring that all the text data is correctly and uniformly structured. - You should be proficient in text data cleaning with experience in standardizing the formatting of textual content. - The data is currently stored in plain text files, so experience working with this type of data storage is necessary.

I'm in need of an experienced Flutter Developer who can craft a comprehensive mobile application. The app should be compatible with both Android and iOS systems. Requirements: - Develop a logistics and delivery app: The project focuses on creating a comprehensive software that can manage delivery services. It should include features such as route optimization, real-time tracking, delivery scheduling, and scanning capabilities. Skills & Experience: - Proficiency in Flutter: The candidate should be well-versed in Flutter development to ensure a seamless and efficient app. - Previous Experience: An ideal candidate should have a strong track record of developing similar applications. - Strong understanding of logistics: Knowledge of logistics and delivery processes is a plus as it w...

I'm seeking a proficient developer to build a comprehensive demo or starter code integrating Snowflake and Kafka using AWS cloud. The ideal candidate should have deep understanding of concepts such as: - Data ingestion - Data transformation - Data storage and retrieval The code should ensure: - Optimal performance - Scalability - Security The code can be written in Python or Java. In-depth knowledge of these languages, as well as experience with Snowflake and Kafka integration, is a necessity for a successful bid on this project.

I'm currently seeking a highly experienced data scientist for applying machine learning techniques on a complex dataset. As a skilled professional, you'll be involved in: - Preprocessing and cleaning of data to remove any inconsistencies. - Conducting exploratory data analysis to unveil hidden patterns and correlations. - Selecting the right machine learning model and evaluating its performance over time. For this project, in-depth knowledge in Python and strong statistical background are highly desirable. Familiarity with supervised machine learning models is a key requirement as well.

...Functions: Data Architecture: Leverage your 5+ years of experience in designing and optimizing database solutions. You’ll work closely with stakeholders to create a robust data architecture that seamlessly integrates various data sources. Programming Languages: Demonstrate proficiency in Java and C#. Your code is not just functional but elegant. Team Leadership: As a seasoned engineer, you’ll mentor junior team members, foster collaboration, and drive technical excellence. Cloud Solutions: Familiarity with Azure or AWS is essential. You’ll architect, deploy, and manage cloud-based solutions. Data Import Strategy: Devise a robust strategy for importing data efficiently, ensuring data quality, and maintaining performance. Collab...

I'm seeking a professional to help me transcribe and code my interviews. Key requirements: - Transcription: I need you to transcribe 1-5 interviews with a high level of detail. You'll be coding, editing, and cleaning up the transcription for clarity. - Thematic Analysis: You're expected to assist in coding the data in a way that captures the essence of the responses in line with the descriptive nature Ideal Skills and Experience: - Proficiency in transcribing and coding qualitative data. - Excellent attention to detail to ensure the transcription is accurate and the coding reflects the nuances of the responses. - Good communication skills to keep me informed throughout the process. If you're confident in your ability to help me with these tasks a...

Please Sign Up or Login to see details.

...project and seeking a professional to help me transcribe and code my interviews. Key requirements: - Transcription: I need you to transcribe 1-5 interviews with a high level of detail. You'll be coding, editing, and cleaning up the transcription for clarity. - Thematic Analysis: You're expected to assist in coding the data in a way that captures the essence of the responses in line with the descriptive nature of the study. Ideal Skills and Experience: - Prior experience with thematic analysis in descriptive research is a must. - Proficiency in transcribing and coding qualitative data. - Excellent attention to detail to ensure the transcription is accurate and the coding reflects the nuances of the responses. - Good communication skills to keep me infor...

I'm in need of an experienced SQL developer who can assist with writing stored procedures in SQL Server. The purpose of these stored procedures is for data loading. Key Responsibilities: - Writing stored procedures for data loading Ideal Skills & Experience: - Proficient in SQL and SQL Server - Prior experience with writing stored procedures - Experience with data loading processes The complexity of the stored procedures is expected to be at the basic CRUD operations level. As this is focused on data loading, it requires someone who is meticulous and well-versed in data manipulation within a SQL environment.

I'm looking to create an application using NoCode development tools, specifically Bubble and FlutterFlow. The core features I need developed are: - User Authentication: This will be based on an email and password login system. The focus should be on ensuring user credentials are securely handled and stored. Experience with implementing this in a NoCode environment is a must. - Database Integration: The project will make use of an SQL Server. The freelancer should be able to efficiently integrate and manage an SQL Server database with the NoCode tools. Previous experience with SQL Server is required. - We need to integrate some process, after all, we need to implement the solution in Azure. In summary, I'm looking for a freelancer who is skille...

I want to create a quiz that can be embedded into a website page builder using their embed feature. The quiz should be manageable from my dashboard, the script will be on it's own domain. Key Aspects: - Creation: The plugin should enable the user to create quizzes. Please advise on the best quiz type to use. - Embedding: The plugin should allow for easy embedding into website pages or blog posts. Being able to place the quiz in a sidebar widget would be a bonus. - Interaction: I am open to different ways for users to interact with the quiz, either by clicking on options, typing answers, or selecting from dropdown menus. Your insights on the most user-friendly option are welcome. - Management: The plugin should provide an interface to manage the quizzes. Ideal Skills and Ex...

I'm in need of an experienced PowerShell script writer, specifically for Power BI associated data management tasks. As part of the project, code will be required to execute the following tasks: - Data extraction from Excel files, CSV files, and SQL databases - Transformation of data, including extraction and update of parameter values from Data Models in each Workspace Ideally, the freelancer would carry a strong understanding and hands-on experience with PowerShell scripting, Power BI, data transformation techniques, and working with database source files like Excel, CSV, and SQL formats.

I have a window cleaning business that I'm looking to expand in York Region, Ontario, Canada. I'm seeking someone who can help me find and secure 50-100 new clients in that area. You can use any method for contacting potential clients, be it email, phone calls, or even door-to-door. Ideal Skills and Experience: - Proven experience in client acquisition - Proficiency in communication and negotiation - Familiarity with the York Region, Ontario, Canada area is a plus Your main tasks would include: - Researching and identifying potential clients in York Region - Contacting clients via email, phone calls, or in person (door-to-door) - Convincing clients to book our residential window cleaning services - Keeping track of and reporting on client acquisition progress Fre...

For my current project, I require an expert who's proficient in DOMO Beast Mode and SQL. The tasks will primarily involve: - Producing calculated fields: You will need to execute both complex mathematical calculations, as well as intricate string manipulations. A good grasp of mathematical principles and string handling in SQL is a must. - Transforming data: This job will further entail the aggregation of data. Being adept in grouping and managing datasets of diverse sizes will be crucial. Your comfort in working with DOMO, SQL, and data manipulation will be the key to successfully accomplishing this task. If you routinely perform these tasks and understand the underlying processes, I would love to connect and discuss the project further.

I'm running a window cleaning company in the York region of Ontario in Canada, and I need help recruiting clients. Here's what I'm looking for: - **Recruitment**: I need someone to focus on recruiting residential houses only, ensuring a continuous flow of work for our team. - **Method**: I'm open to various methods for reaching potential customers, from traditional cold calling to any other approach you are comfortable with. However, I'm not interested in online advertising. - **Requirements**: The houses you recruit must be in the York region. Additionally, each recruited house should provide a minimum of $200 in business. Free Trial Opportunity: As part of our hiring process, we're offering a free trial period to assess your ability to generate re...

I am seeking an experienced developer who is well-versed in React JS and Node JS for the development of an e-commerce platform. This platform will be designed to support a range of e-commerce functions, with the main focus being on product search and filter options. Key responsibilities & requirements: - Proficiency in React JS for front-end development - Experience with Node JS for back-end development - Strong understanding of e-commerce structures and functionalities - Ability to integrate user-friendly product search and filter options The ideal candidate should be someone who has not only the technical expertise, but also the vision and creativity to enhance the user experience through these key functionalities. A portfolio showcasing previous e-commerce projects would be a s...

I require an expert proficient in Python, SQL, and Java to work on a Codility assessment. The assessment will be conducted at an intermediate level and will be inclusive of various tasks that I will be solving in the language of the question. Key Requirements: - Comprehensive Knowledge in Python, SQL, and Java - Proficiency in tackling Codility assessments - Understanding of the assessment's specific concepts and frameworks Remember to adhere to Codility's test format and code-writing guidelines. Your completion and success of this project will greatly depend on your ability to grasp and execute these particularities.

I am looking for a skilled and experienced web developer to build a simple and engaging website for my data analytics agency. Key Functionalities Required: - A clean, professional design that reflects the precision and detail-oriented nature of our work. - Clear sections displaying our primary services which include data visualization, predictive analysis and data cleaning. - A section to attract new clients through compelling calls to action and persuasive content. - An informative section providing detailed information about the various services we offer. - A project showcase space, where we can exhibit our previous projects and achievements. While there are no specific color schemes or branding guidelines to adhere strictly to, I'd prefer a de...

I'm seeking a professional who can assist in generating leads and potentially converting them into clients for my window cleaning business. The leads should be specific to suburban neighborhoods and residential areas, with a primary aim of increasing sales. Key Responsibilities: - Identify and gather leads from the specified suburban neighborhoods. - Develop strategies to convert these leads into potential clients. - Prioritize on generating leads that have a higher likelihood of converting into sales. - Maintain a professional and engaging approach towards potential clients. Free Trial Opportunity: As part of our hiring process, we're offering a free trial period to assess your ability to generate leads effectively. During this trial period, you'll be tasked with ...

I need assistance to solve three coding tasks using Python, Java, and SQL. The challenge involves - Analytical problem-solving - Implementing quality checks - Code compilation The challenges require proficient skills in the aforementioned languages, while also ensuring code efficiency. Prior experience in problem-solving and understanding how to efficiently check and maintain the quality of code is a big plus.

Skills -core php, laravel, Codeigniter my sql database Min 1 to 5 year experience location - Mohali,Punjab, India

I'm looking for someone who has very good experience in Laravel's real world situation. What Queue drivers are available in Laravel? Will ignore any replies without answering to the above my question. Here is my problem now. We are using Laravel project and it's running on production. It's using Queue heavily and queue driver is database now. We are getting following issue. SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction (Connection: mysql, SQL: select * from `jobs` where `id` = 111111 limit 1 for update) Let me know how to fix this then I will hire you immediately and you can be employed in our project. Please don't waste my time if you don't know what's going on with the above message.

...skilled professional who can help me scrape text data from e-commerce sites for data analysis. Key Requirements: - Data Scraping: The primary task is to extract text data from various e-commerce websites. This includes product descriptions, reviews, and any other relevant textual information. - Data Cleaning: Ensure the scraped data is accurate, clean and ready for analysis. - Data Analysis: This project is focused on data analysis, so experience in this area is a must. The ability to extract meaningful insights and trends from the scraped text data is crucial. Ideal Skills and Experience: - Proficiency in Web Scraping: A strong background in web scraping and working with text data is essential. - Data...

I'm in need of assistance with Codility assessments, specifically focusing on intermediate-level problem-solving tasks. Your work should encompass: - Expertise in SQL or Python. Familiarity with both languages is advantageous. - Proficiency in algorithmic programming, capable of thinking strategically to solve intermediate-level problems. - Ability to assist in solving three different task types in Codility, including: 1. Time complexity problems 2. Sorting and searching problems 3. Counting elements problems Ideal candidates would have experience preparing or mentoring for codility assessments and a strong background in programming. Your intricate knowledge of problem-solving within the realms of algorithmic programming would be highly beneficial. A methodical appro...

I hope you are well, sorry for the rush. I always give you the highest quality work and am ready to be by your side anytime. I hope you are happy with my service. I hope to get good comments from you. We will work together more thanks!

I urgently need an expert Laravel developer to collaborate on a web application development project. The specific features and ...an expert Laravel developer to collaborate on a web application development project. The specific features and functionalities of the project are yet to be defined, but a vast knowledge in Laravel is key. Key skills and Experience: - Proficiency in Laravel and PHP - Understanding of MVC design patterns - Knowledge of front-end technologies, such as JavaScript, HTML5, and CSS3 - Familiarity with SQL/NoSQL databases - Excellent problem-solving skills The timeline for this project is ASAP, so the ability to work under pressure is required. If you have experience in web applications, APIs, or both, it will be advantageous. Let's collaborate on this ex...

I require an expert capable of uploading an Excel dataset into S3 using Lambda and Snowflake to produce reports. The focus will be on identifying data anomalies over time. Your responsibilities will include: - Loading Excel data into S3 - Implementing Lambda and Snowflake for data processing - Generating time-series reports on data anomalies Ideal skills for this role include proficiency in AWS S3, AWS Lambda, and snowflake, with a keen understanding of time-series analysis in Excel reports. Experience in identifying and analyzing data anomalies is also a key component for this project. The aim is to visualize the irregularity in the data, enabling me to make informed decisions based on these reports.

I'm in need of someone skilled in both astrology and mathematics. I require accurate calculations of planetary positions and insightful astrological predictions. merging the disciplines of Western astrology with numerological techniques. Required Skills: - Proficiency in Western astrology methodologies - Numerology knowledge, particularly in relation to astrology - Competency in astronomy-based mathematical computations - Experience generating astrological charts and predictions

I need a simple form that will look goo...form will collect NAME EMAIL CITY PHONE NUMBER phone number will be a formatted 10 digit max, and email will need validation for properly formatted. This will take the data and post it to our existing base and will then revert form back to a page that says success, and then auto redirect to the form page. The form page will look neat and clean and also contain a couple lines of text and our logo. You will use the existing config file to connect to our base, instead of creating a new one. This project needs completed today and should only take an hour to complete. This is to be written in php 8.2 and connected to sql dbase. You will be paid $30 when it is complete and verified to be working on our server. Ping me if you can co...

I have a database that I need to be cleaned up. The main task is to remove duplicate entries. Key Points: - Main Task: The primary goal of the data cleaning project is to remove duplicate entries in the database. - Handling Duplicates: The duplicates should be automatically deleted, not merged or manually reviewed. Ideal Skills & Experience: - Database Management: A strong background in database management is crucial for this task to ensure the data is processed correctly without compromising the database integrity. - Data Cleaning: Experience with data cleaning processes, especially in handling duplicate records, is important. - Automation: The ability to automate the deletion of the duplicates efficiently and accurately is essentia...

...to take part in my ongoing web development projects. The main goal of the project is to enhance an existing application. Requirements: - Proficiency in .NET for backend development - Strong experience with Angular for frontend development - Excellent understanding of SQL Server and MongoDB databases - Previous work with DevExpress is essential Your responsibilities will include: - Developing APIs using .NET for enhancing the application - Integrating Angular for improving the frontend - Ensuring seamless operation with SQL Server and potentially MongoDB Ideal candidates should have a strong understanding of web development and be able to contribute effectively to enhancing the current state of the application. The ability to work with a team, meet deadlines an...

I urgently require a thorough cleanup of my contact database. The main tasks include: - Verification of the correctness of email addresses - Authenticity check of RUTs - Verification of phone numbers The right candidate for this project should possess excellent attention to detail and experience in database management, particularly in contact cleaning. Familiarity with RUT verification will be highly valued. Please apply only if you can start immediately.

...FINAL; NO LATER CHANGE IS ALLOWED. READ CAREFULLY BEFORE YOU BID. See ATTACHMENTS. Cannot share Code before you accept. I have a Journal App built in PHP/JavaScript/Laravel which allows to enter Journal entries, country, some photos and one video of limited size, different costs etc (see ). The job is to implement the feature of Travel Route Map Creation using Leaflet and OpenStreetMap (both free, opensource). There is a tutorial here Users will be able to search a place in map, create lines of different colors from one place to another, add/tie blog posts, links and pictures with the map, dates, notes and then only map creator can download the map as Image/PDF. Leaflet free plugin

I'm in need of someone skilled in both astrology and mathematics. I require accurate calculations of planetary positions and insightful astrological predictions. merging the disciplines of Western astrology with numerological techniques. Required Skills: - Proficiency in Western astrology methodologies - Numerology knowledge, particularly in relation to astrology - Competency in astronomy-based mathematical computations - Experience generating astrological charts and predictions

Complete SPSS data analysis to test hypotheses relating to social media usage and exercise addiction. The goal is to identify and delineate trends and patterns from the data. Include a report for the results using APAstyle

I am looking for a freelancer to assist me with specific data cleaning and transformation tasks in Microsoft Power BI. Skills and Experience: - Strong proficiency in Microsoft Power BI - Experience in data cleaning and transformation techniques - Ability to work with large datasets Data Output: - The preferred format for the data output is data sets Data Collection: - I already have the data, so the freelancer will not need to collect it.

I'm looking to have a Python API built to generate a multiple-choice question bank for schoolchildren in various subjects (such as Mathematics and English) using AI APIs like ChatGPT. The API should allow for different difficulty levels for the questions. Key Requirements: Development in Python. The API should possess the following functionalities: Input Parameters: a. Users will specify the number of questions needed in one set. b. Users will indicate the topic of the questions. For example, if they want a question bank on Mathematics focusing on BODMAS, they will provide keywords like "BODMAS." Users can provide multiple keywords such as "BODMAS," "Ratio," "Percentage," etc. Similarly, for English, keywords could include "Cloze,...

Hi, Job Title: Senior Developer - SQL Server Analysis Services Experience : 5+ Mandatory Skillset:Seeking a skilled SSAS Developer to contribute to our team's success. Responsibilities include designing, developing, and maintaining SQL Server Analysis Services solutions for business intelligence and data analytics requirements. Tasks involve creating data models and developing multidimensional cubes. Key skills required: expertise in MS SQL Server Analysis Services (SSAS) Tabular and Multidimensional. Proficiency in TSQL for writing performant queries is essential. Experience with data visualization and reporting tools is highly valued. Additional knowledge of Excel and .Net development is advantageous. Strong problem-solving abilities, exce...

I need an expert to help with advanced troubleshooting and optimization for my Oracle database. The ideal candidate should have: - Proven experience in database administration. - Proficiency in Oracle database. - Expertise in database troubleshooting and performance optimization. - Adept in using SQL Developer for managing database tasks. You'll be handling tasks such as: - Identifying and resolving performance issues. - Suggesting and implementing optimizations. - Monitoring database activities to ensure smooth operations. Your role will be crucial in ensuring the efficiency and security of our Oracle database.

Project Description: Customer Data Integration and Personalized Marketing System Introduction: In the contemporary business landscape, understanding and catering to the needs of customers is paramount for organizational success. To achieve this, businesses must gather, organize, and analyze data about their potential and existing customers. This project focuses on developing a comprehensive system to streamline the process of collecting, integrating, and leveraging customer data to create personalized marketing campaigns. Objective: The primary objective of this project is to establish a dynamic and continuously updated database that empowers personalized marketing strategies. By gathering, cleaning, integrating, and analyzing customer data, the system a...

...calculate the hourly rate and the time needed to complete different task documents, on an agreed fixed price. The best offers with the right experience will have the opportunity to work with us on a long-term basis. Also, Good prospects for the right developers, based on the performances evaluated over a period of time, once you established your skills. Need to provide the changed code details and sql queries if any at the end of each sub-task, with the changed code line numbers. Unlimited Revisions are needed. Any bugs created due to your own developments are to be fixed on free of Charge. Recruitment is for a long-term big project as such, all the developers are subject to practical skill test for which not paid. Please send your details for the below-mentioned questions....

I have an error in my asp.net MVC application. The form is using AJAX to show particular dropsownlist data. its working fine but if the validation works, the ajax call is reseting and stop working.

we are looking for a senior experienced PHP developer with a minimum of 15 years of experience Skills and Experience MUST HAVE: - 15+ years of core PHP development experience. - Proficient in Laravel framework. - highly knowledgeable in php programming and experience SQL Injection prevention/fixing - Finding and Securing any loop holes in the system - **must be an independent developer, not an agency! - must be able to work on github - lastly making sure platform is mobile responsive Must have experience in social media or multi-user platform, chat system, ecommerce platform *******We will only hire independent freelancer. If you are an agency, if you are a marketing person or project manager and will delegate the work to someone else, meaning, will subcontract the job to someon...