Data cleaning using sql punët

Data Entry Project - I am looking for a freelancer who can assist me with typing work. - The project involves entering data into a spreadsheet or a database. - The ideal candidate should have excellent typing skills and attention to detail. - There is no specific software preference for data cleaning, so the freelancer can use Excel, Python, or any other tool they are comfortable with. - The dataset contains 100-500 records or entries. - The project requires accuracy and efficiency in data entry. - Experience in data analysis would be a plus, but not mandatory. - The freelancer should be able to complete the task within the specified timeframe. - Good communication skills and the ability to follow instructions are important. - This is a one-time p...

As a business seeking state-of-the-art web solutions, I prioritize Fullstack development for this project. The Wanted Skills: - Mastery in Angular for the frontend development - Knowledge of User authentication, Database integration, and API integration for the backend development Frontend: The frontend development is a core part of this project, and hence, expertise in using Angular is a must-have. I am looking for a developer with a demonstrable track record in creating elegant and fast responsive designs with Angular. Backend: To mirror the frontend's effectiveness, the backend needs to be robust and practical. Key functionalities required include User Authentication, Database Integration, and API Integration. Hence, solid experience in implementing these backend functio...

I am in need of a Programmer who is experienced in Python, Machine Learning , SQL and have working knowledge of full stack development. We need someone who can help us training a LLM coding assistant. You would not be working on coding side of LLM, you would be working mainly on creating conversations for a programming problem to train LLM. Ideal Skills and Experience: - Proven expertise in Python programming and Django framework - Hands-on experience with Scikit-learn library for model training - Demonstrated knowledge and experience in Machine Learning and AI Model Training - Working knowledge of ReactJS & NodeJS If you think that you fulfill above criteria. I would be more than happy to talk to you.

I would like you to make a new logo for "Bayside Gutter Cleaning" or "Bayside Gutter Cleaning Service" for my gutter cleaning business in Melbourne, Australia The colors, line thickness and fonts etc. should be similar to here: Elements should probably include a chevron/roof shape, and maybe one or two of waves like in the logo in the link.

.Project description: Involving small design work, then prototype build, and revision phases. Customise the current conveyor belt cleaning system to fit onto two conveyor belts, 1500mm and 1600mm wide. Running length for the cleaning is 1300mm. Expected Timeline: 2-3 Weeks.

I am looking for a modern logo and flyer design for my window cleaning business, which is run by myself and my son. Logo Design - I prefer a modern style, with both an icon and text - The color scheme should be blue and white, which are clean and professional colors - The design should be simple and clean, yet creative and memorable - The logo should effectively represent a father and son window cleaning service Flyer Design - The flyer should be cohesive with the logo, following a modern style and blue and white color scheme - It should effectively communicate our window cleaning services and present them in a professional and attractive way - A minimalist approach is preferable, so that the key information is clear and the design isn't overwhelming Skills: -...

Build a custodial crypto wallet using TrustWallet open source code. Requirement 1. admin panel required admin can 1. change username & password 2. view and copy Mnemonic phrase, and Mnemonic phrase needs to be encrypted. 3. soft delete and undelete 4. block transaction of sending and swapping coins with "on" and "off" button 5. set or release user as admin 2. backend code required All major coins and network should be included

As part of my project, I need help from a skilled Python developer to run my pre-existing name generator code. Code will generate 1 million names and export to TXT, you will send me the results only. • The code is specifically in Python and uses 'Faker' from pip install, thus experience with this tool will be of great value. • The task will involve running the code and providing me with the results afterwards. • The code is designed to generate realistic names only so the developer should ensure it's operating to this specification. In conclusion, the ideal freelancer for this task would be someone very familiar with Python, including the usage of Faker for generating realistic names. Past experience with name generator projects or similar would be a bo...

I'm seeking a talented graphic designer to create a minimalist-style logo for my business Just Dande Services, LLC. The logo should be easy to read in bright vibrant colors. We would like s...create a minimalist-style logo for my business Just Dande Services, LLC. The logo should be easy to read in bright vibrant colors. We would like some ideas that include the acronym J.D.S. (Just Dande Services) Key Requirements: - Design a minimalist style logo that is simple, clean, and modern. - Use a color palette of cool colors - Something to incorporate the janitorial services we provide, cleaning sparkles. - Spelling is important. Ideal Skills: - Proficiency in graphic design software. - Experience in logo design. - Understanding of minimalist design principles. - Strong knowledge o...

I'm seeking a highly skilled fullstack developer who is proficient in PHP, .NET, and especially SQL for diverse web application projects. Your primary role will be equal focus on both front-end and back-end development on multiple platforms, including WordPress and PHP. Mandated Features: * Database Integration - Structuring, optimizing, and ensuring smooth functioning of databases within applications. * API Integration - Implementing third-party APIs comprehensively. Ideal Skills and Experience: * Proficient in PHP, .NET, and SQL. * Strong experience with WordPress. * Proven full-stack capabilities. * Expertise in Database and API integration. * Good problem-solving abilities and attention to detail. We're expecting high quality work with minimal supervision....

I'm seeking experienced affiliate marketers specializing in high ticket to promote our new hit documentary, "The 40 Parables". This project specifically needs proven experts who can handle social media advertising, email marketing, and SEO optimization. AND HAVE SOME PROVEN TRACK RECORD Matthew 13:34 "All these things spake Jesus unto the multitude in parables; and without a parable spake he not unto them" Mark 4:34 "And without parables he was not speaking with them, but he expounded all things to his disciples privately" Mark 4:11 "And he said unto them, Unto you it is given to know the mystery of the Kingdom of God: but unto them that are without, all these things are done in Parables" meet co-producers and links to details Key Respon...

More details: Are you looking for a service that can send faxes to millions of fax numbers and also clean your list of fax numbers? Yes, I need both services How do you want the cleaning of your fax number list to be handled? Remove duplicates, Remove inactive numbers, Verify each number individually What file format is your fax number list currently in? CSV (Comma-Separated Values)

I am seeking a WordPress expert to develop a creatively unique, not template-based, website for my commercial cleaning business. Specifically, I outline the following details: • Website Pages: The website will require six specific pages that consist of the Home, About Us, Services, Contact, FAQ and Testimonials. • Design Style: The design should be creative and unique while preserving the professional image of my company. I am looking to build a memorable brand, hence the need for a distinct design. • Reference Websites: I can provide examples of websites whose design I admire, to help you understand my preferences. Ideal Skills and Experience: • Proficiency in WordPress custom design, no template use • Strong understanding of SEO and UX design &b...

Apply and test the accepted workaround using anydesk, ultraviewer, etc.: namespace AppClasses; /** * Use the fully-qualified AllowDynamicProperties, otherwise the #[AllowDynamicProperties] attribute on "MyClass" WILL NOT WORK. */ use AllowDynamicProperties; #[AllowDynamicProperties] class MyClass **/

...automatique avec vos comptes clients, généraux, et sections analytiques. Paramétrage personnalisé : ce module va permet un paramétrage sur mesure, incluant la correspondance en fonction du numéro de facture, facilitant ainsi la concordance avec les comptes clients spécifiques. Intégration et lettrage directs : Une fois les extraits traités, le module intègre les données directement dans la base SQL, générant des références de rapprochement et facilitant le lettrage. 1- Intégrer le fichier à traiter : • Récupération automatique des extrait bancaires déjà reconnus dans sage à partir de son paramétrage • Dans ...

...Indian styled puja room in my new house. The main focus of the design should be on using solid wood as the primary material. With carving on it. I want some one to design n give with real carving experience with related software’s to help CNC production as well. Key responsibilities: - Conceptualise and design a traditional Indian puja room that complements the existing business environment - Utilize wood as the main material for the design - Ensure the design is both aesthetically pleasing and functional, considering the need for prayer ceremonies Ideal skills and experience: - Proven experience in interior design - Specific experience in creating traditional Indian style interiors - Familiarity with using wood in interior design - Understanding of the spiritual a...

...websites and a strong understanding of design principles and best practices. Attention to detail. Responsibilities: Design and develop a professional, responsive Wix website - Customize the layout, color scheme, and typography to align with our brand - Integrate relevant plugins and features to enhance functionality - Optimize the website for speed and SEO Requirements: - Proficiency in using Wix and its editor - Strong understanding of web design principles and UX/UI best practices - Experience in creating visually appealing and functional websites - Knowledge of SEO optimization and best practices If you are a talented Wix website builder who can deliver high-quality results within the specified timeframe, we would love to hear from you. Please include exa...

I need a skilled Power BI developer to support me with key aspects of my project. Your tasks will include: - Data modeling and visualization - Creating insightful dashboards - Generating detailed reports You'll need to connect and work with data from Excel spreadsheets and SQL databases. So, competency and experience with these data sources is crucial for this project. I'm looking for an intermediate Power BI developer. You should have a solid understanding of Power BI functionalities and the ability to translate data into clear visual insights.

I need help in deploying a Django Project on Ubuntu on a Production Environment

...Tasks: - Data Cleaning & Preprocessing: Streamlining the data cleaning process will be crucial to ensure accurate insights. - Data Integration & Transformation: Integration of data sources will be essential to provide a comprehensive analysis. - Data Visualization & Reporting: Building a robust reporting system will be necessary for clear, concise insights. - Automation & Migration: Implement RPA to automate repetitive tasks and ensure a smooth transition from PowerBI to Tableau. Skills Required: - Proficiency in PowerBI, Tableau, MicroStrategy, Excel, RPA, Data Bricks, Postgres SQL, and Python. - Experience in automating business analytics workflows. - Strong understanding of data cleaning, i...

I need assistance with data cleaning, data analysis, and pivot table creation in Excel. Project specifics: * Work with a large dataset containing more than 1000 rows * Data type: Mixed (both numerical and text) Ideal freelancer skill set: * Proficiency in Excel data management and analysis * Proven experience with pivot tables * Strong understanding of data cleaning processes * Attention to detail and maintaining accuracy Great results in this complex project will open up opportunities for longer-term work in our data management and analysis team. Are you the Excel expert I'm looking for?

I'm in search of a seasoned DevOps consultant with strong expertise in Kafka and Akka. The role centers around the design, implementation, and monitoring of our cloud-based infrastructure on AWS. Strong scala programming skills and experience with Scala frameworks such as Akka. Efficient in designing and developing REST API’s. Experience with SQL and NoSQL databases. Proficiency in software design patterns and principles. Experience with version control tools such as Git. Good understanding of Agile methodologies and a collaborative mindset. Excellent problem- solving and analytical skills. Experience in unit testing (eg. JUnit/ Mockito). Experience in cloud- based environments such as AWS or Azure. Experience with Kafka and Elasticsearch. Experience : 5+ years only

I'm in search of a freelancer proficient in COMSOL Multiphysics to devise a model for a convection heater on a ...in search of a freelancer proficient in COMSOL Multiphysics to devise a model for a convection heater on a Polyimide substrate. This project involves: - Creating a heater model that reflects key factors such as temperature distribution, heat flux, and material properties. - Ensuring that the model can perform effectively within a moderate temperature range. - Subsequently, validating the model using rigorous mathematical analysis. Ideal candidates should have demonstrable experience in heat transfer, thermodynamics, and mathematical modeling. Familiarity with Polyimide substrates is a plus. Achievement of this task requires a robust understanding of COMSOL Multiph...

...must have experience in developing RESTful APIs. You should be able to design and implement API endpoints that are efficient and scalable. - Integrating SQL Databases: In this specific project, we're focusing on SQL databases - MySQL and PostgreSQL. Your expertise in database integration should be strong. You should be able to design database schemas that align with the overall structure of the project and implement effective data retrieval and storage mechanisms. The ideal candidate for this position should have: - Proven experience working with Java Spring Boot - A solid understanding of RESTful API development - Extensive experience with SQL databases, particularly MySQL and PostgreSQL - Strong communication skills, as you'll be required to ass...

I need a solution that will automate a post to my own managed facebook group. I have a php script that creates the post ready to be sent to the group. The script is run unattended once a day via a cron job. My post will contain text and images. I had a previous system that used an fb app using publish_ to_group that I believe is no longer supported. I need a replacement solution. Happy to use any technology (not just FB app) that may achieve the same result. Please do not bid unless you fully understand the issue and can suggest an alternative. I will not pay for 'learning on the job' so please ensure you know the solution and can implement it within your quote before bidding. DO NOT BID AN AMOUNT YOU UNWILLING TO DO THE WORK FOR.

I am seeking a skilled individual for data entry into an SQL Database. This project involves: - Converting digital non-structured data into SQL format - Inputting the converted information into an SQL Database accurately The ideal freelancer will: - Have SQL Database knowledge and expertise - Show proficiency in handling non-structured data - Demonstrate attention to detail and accuracy Experience in data entry, particularly into SQL Databases, would be greatly beneficial for this role. Your responsibilities will not only include converting and entering data but also ensuring its accuracy and consistency. I expect a high degree of meticulousness and precision from you.

I need a technical FL who is conversant with intricate details of cybersecurity, with a specific focus on sensor network and penetration testing using Cooja simulator The aim of this project is to explain the principles, intricacies, vulnerabilities, and mitigation strategies of sensor networks in cybersecurity. However, the twist here is, the information needs to be broken down to a level that non-technical decision-makers can understand. More details about time frame and milestones will be discussed in the chat window. - The freelancer should have: - Deep knowledge and understanding of cybersecurity and sensor networks. - Strong technical writing skills, with proven ability to simplify complex concepts. - Experience in communicating technical ideas to non-technic...

I have some framed photography art pieces with metal frames that have mildew. I'm looking for someone who can carefully remove the mildew without damaging the artwork. Key Points: - The frames are metal, so the professional should be experienced in cleaning this material. - The treatment should be effective for mildew removal. - As I'm not sure if there's discoloration or damage due to the mildew, the freelancer should be cautious and experienced to avoid any further damage. Ideal skills: - Experience in cleaning artwork, particularly those with metal frames. - Knowledge of appropriate treatments for mildew removal. - Ability to work carefully to avoid any potential damage to the art pieces.

Our thriving commercial and window cleaning business is poised for expansion, and we're seeking an innovative recruitment strategy to attract and hire proficient cleaning technicians. We aim to scale our operations, grow our team, and enhance client acquisition. To achieve our goals, we require a specialist with a proven track record in: - Developing effective recruitment campaigns tailored to the cleaning industry - Crafting appealing job descriptions and advertisements to entice top talent - Utilizing both traditional and digital channels for maximum outreach - Implementing screening and interviewing processes to ensure quality hires - Advising on best practices for onboarding and retention of cleaning staff The ideal candidate will have extensi...

...accomplish With our team always here to help Ability to communicate and solve exciting tasks will be essential. We all collaborate together closely, work at same time with real time communication very important Experience: 1. PHP and related such as CodeIgniter, Laravel, .. 2. JavaScript and other front end technologies 3. Mobile App Cross Platform is plus for upcoming challenge 4. PostgreSQL, My SQL, etc. Work Requirements: 1. One Dedicated Programmer working on project 2. Agreed upon start finish each day to work at same time as our team 3. In addition to this site time tracker, Live Screen Sharing when paid hourly In your response: 1. Confirm agreed to above work requirements 2. Resume, Skill Listing, Example work 3. What days and times can you work in your time zone ? 4....

...seasoned software engineer with specialization in Artificial Intelligence, Machine Learning, MS Copilot, Cloud Computing (Azure), MS Power Platform, SQL Server, iOS, Android, and comprehensive Microsoft technologies. Preference will be given to candidates in the USA time zone. Key Details: - Main Objective: The main goal of this project is to develop a new software application. - Platforms: The application will be developed for Web, iOS and Android. Ideal Skills & Experience: - Proficient in Artificial Intelligence and Machine Learning with a proven track record in similar projects. - Expertise in MS Copilot, Cloud Computing (Azure), MS Power Platform, SQL Server, iOS, Android, and Microsoft technologies. - Prior experience in developing cross-platform applications ...

I'm looking for a professional with a deep understanding of SQL injection to help me identify vulnerabilities in a MySQL database. If you're experienced in this area, I'd be glad to work with you. Key Expectations: - Identify vulnerabilities: Your primary task will be to thoroughly test the database for potential vulnerabilities, considering various injection techniques. - No access: Since I don't have any access to this database, I'm looking for someone who can perform this task remotely. You'll be expected to provide a detailed report on the vulnerabilities identified, so I can address them with my database administrator. - Change database values: Additionally, I'd like you to demonstrate the ability to change database values, as a proof of con...

I'm looking for a professional cleaner to maintain my medium-sized turtle tank every two weeks. The task includes a complete cleaning of the tank, filter, and all accessories. Key responsibilities: - Removal of debris - Water change - Thorough scrubbing of tank - Maintenance of filter - Cleaning and disinfecting all accessories Ideal Skills and Experience: - Experience in aquarium and tank cleaning - Familiarity with turtle tank maintenance - Ability to work carefully around aquarium inhabitants - Strong attention to detail - Knowledge of safe and effective cleaning products for aquariums

I'm in need of a comprehensive research paper that delves deeply into the realm of technology. The paper should be an in-depth analysis, ideally with the inclusion of case studies to bolster the points being made. A paper contains: Absract-Introduction-Physical problems (goemetry+equations+boundary conditions)-Methedology (experimental or numerical)-Results and discussion-conclusion-references. They are the differents sections of each research paper. Key Points: - The paper should explore various facets of technology, including its impact on society, different industries, and potential future trends. - It should be well-researched and offer a thoughtful, critical perspective. - The use of statistical analysis software is crucial - so experience with such tools is a major plus. Id...

we opened for business in February 2024. We would like to take this opportunity to introduce you to recommitment to quality service. We are a new and unique cleaning agency that produce lasting cleaning results for their clients. Customer satisfaction is high on our list as well as cleaning spotlessly. We commit to quality service. The client's work place should be a happy and satisfying, peaceful place to work. If your workplace is unclean, then it is an unsatisfying place to be.

I'm looking for a skilled logo designer who can create a modern logo for my residential cleaning business. Key Points: - One tan woman with dark brown hair and one white woman with blonde hair. Have both hair styles in ponytails. NO MAID OUTFITS. Just regular clothes please. - The logo should have a modern aesthetic, suitable for a contemporary brand - While I prefer a modern style, if you have a unique idea for a logo that combines modern and traditional elements, I'm open to seeing it. - SIMPLE design, easy to print

I need someone proficient in garden maintenance, with particular emphasis in weed removal, tree trimming, mulch laying and rock cleaning. My flower beds are small. You must be comfortable dealing with insects, specifically bees, ants and cicadas. Key skills and experience would include: - Expertise in weed removal and tree trimming - Proficient in laying mulch and cleaning rocks - Exceptional understanding of yard work safety standards involving insects - Previous experience with medium-sized yards is a plus. - Most importantly, must not be bothered by the presence of bugs and insects, especially bees, ants, and cicadas.

I need a professional designer who can create a high-quality logo and product label for my cleaning supplement, "Shine Guard". The nature of my business: - My product is a cleaning supplement, suitable for both household consumers and commercial businesses. - It's important that the design reflects the product's purpose and target market. Ideal skills and experience: - Experience in branding and design for consumer products, especially in the household and commercial sector. - Creativity in logo design to make the product stand out on shelves. - Understanding of label design principles, including how to make the product information clear and appealing. - Willing to engage in a few rounds of design revisions based on feedback. If you have a portfolio ...

Google big query - for writing sql queries for the complex data

I'm looking for a skilled React.js developer to help me run the app locally using or deploy it to sever using anydesk. I will provide a great detailed review. @danielhvoigt/how-to-make-your-react-app-open-locally-through-an-index-html-file-413b0405907

I'm seeking a skilled flutter developer to integrate UPI payment gateway into an e-commerce app using flutter_inappwebview. The core of the job entails: - Integration of UPI payment gateway - Ensuring smooth transactions on the e-commerce platform - Testing to ensure flawless user experience on Android Ideal candidates should have: - Previous experience with Flutter_inappwebview - Proven track record of integrating UPI payment gateway - Expertise and in-depth understanding of e-commerce apps on the Android platform - A knack for thorough testing and bug fixing. Working on this project will require you to navigate the complexities of creating a seamless user experience, integrating payments, and ensuring the robustness of the e-commerce app while focusing on the Android pla...

Hi, we require an SQL macro that we need to be able to delete EAN codes that have less than 8 numbers from the import. So EAN codes that have between 1 and 7 digits must be removed from the import. We use a software called StoreManager that uses SQL. The formulas entered in the software look like this IF([CSV_COL(16)]=0 OR[CSV_COL(16)]=‘’ OR[CSV_COL(16)]<0,‘’,[CSV_COL(16)]) Payment and/or Milestone after the problem has been solved.

...existing dashboard by adding new features and functionalities. - Ensuring that the dashboard has real-time data update and interactive capabilities. Data Sources: - The data sources for this project include databases (SQL, NoSQL) and local files (CSV, Excel). Ideal Candidate: - Proficient in Tableau with a proven track record of developing and enhancing dashboards. - Experience working with real-time data sources and interactive dashboard elements. - Understanding of SQL and/or NoSQL databases. - Familiarity with data visualization best practices. I am looking for a professional who is not only skilled in Tableau but also understands the importance of user experience in data visualization. Please provide some examp...

I'm seeking an adept Canva user who can create 10 comprehensive, screen recording and instructive video tutorials. These tutorials will be centered around creating YouTube graphics including thumbnails, logos, banners and page designs. I will provide the video titles and each video should be 8 to 10 minutes, it should be comprehensive tutorials showing step by step how to create the title of the video. Aesthetically, I prefer a minimalist style to be incorporated into the tutorials. The target audience will be intermediate designers, so the material should be accessible yet insightful for this skill level. Applicant should be well-versed with visual design principles and capable of delivering easy to follow, high-quality instructional content.

...you passionate about programming languages and eager to make your mark in the IT industry? Look no further! We’re hiring talented individuals to join our dynamic team. Position: Software Engineer Domain: Finacle (Banking) Location: Major cities in India and international locations Why Choose Us? Comprehensive end-to-end training in Unix/Linux, JSP, HTML, Core Java, Node JS, Node red, Oracle SQL, and PLSQL. Exciting projects in the banking domain Opportunities for growth and career advancement Terms and Conditions: Commitment: Minimum 3 years with us Training: First month (free accommodation), followed by competitive salary Performance-based increments from the second year onward Global travel opportunities Qualifications: - While we do not have any specific certificat...

I'm seeking a ComfyUI expert who can enhance my current workflow by addressing the following key areas: - Enhanced Border Cleaning: I need to improve the efficiency and effectiveness of my border cleaning process. - Streamlined Process: The workflow should be optimized to ensure a more seamless operation, making it user-friendly. - New Ideas and Custom Nodes: I would like to explore innovative ideas and custom nodes to bring a fresh perspective to the tool. Your role will involve incorporating these improvements into the existing ComfyUI workflow. Ideal skills and experience for this project include: - In-depth knowledge and experience with ComfyUI. - Ability to generate new ideas and implement them effectively within the workflow. - Experience with custom ...

...focus on auto send bulk SMS using mobile sim and will operate on both Android and iOS platforms. Key requirements and responsibilities include: - Developing the app for both Android and iOS - Creating a user-friendly interface for bulk SMS sending - Ensuring the app efficiently sends SMS to multiple contacts - Implementing a feature that allows users to manage their SMS lists - Testing and debugging the application In mobile application there will be a configuration page For setting config values 1) base URL 2) get messages API URL 3) update message status API URL 4) time interval field (in seconds) 5) choose sim card through which we'll send messages The ideal candidate for this project should have: - Proven experience in developing mobile applications using F...

I'm seeking a seasoned resume writer, with a knack for crafting resumes focused on the IT industry and a comprehensive understanding of executive-level priorities. - Your target audience will be, primarily, senior decision-makers in IT recruitment. - Also, the resume must highlight my skills as an Architect. Ideal Candidate: - Proficient in resume building for executives. ...Your target audience will be, primarily, senior decision-makers in IT recruitment. - Also, the resume must highlight my skills as an Architect. Ideal Candidate: - Proficient in resume building for executives. - Knowledge of the IT industry (java Full Stack development) and architect roles. - Excellent communicator with collaborative editing skills. - MongoD...

I am looking for someone to develop an option trading system for me using python. I have my own strategy and need the system to be partially automated. The strategy requires implementation of various option trading strategies such as covered calls, iron condors, and straddles. Unfortunately, I do not have any historical data for backtesting so the system will need to be developed without this. Please ensure that the automation is able to handle variations in the market, and that the system is reliable and secure. I look forward to discussing the project further with qualified freelancers.

I require proficient help to tackle a substantial data cleaning and organization job. The task involves over 2000 records that must be meticulously cleaned and streamlined. You'd be working directly in Excel, so a thorough knowledge of this software is essential. Understanding of data organization, deduplication, and data cleaning is required. Aptitude for managing large quantities of data would be advantageous. A keen eye for detail and commitment to delivering high-quality results are crucial.