Sql combine columns from two tablesKazi

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.

We are in need of a talented designer to create a poster for an upcoming concert we are hosting in Brussels on 26/10/24. The theme of the concert revolves around bagpipes and hunting horns, and so it's crucial that the design captures the essence of these two different instruments. There will be two bands at this event: "Les Echos de Ciergnon" (Hunting Horn): "The Blue Stones Pipes and Drums"(Bagpipes): WARNING: make sure you use the right instruments in your design !!! it is a HUNTING HORN (not a French Horn) !!! The hunting horn is less sophisticated. Key Information: - The poster should include the date and time of the concert, as well as the venue location. Please review the attached document: the poster should include the text provided. Ke...

There is a website that I do not have access to the hosting and I just need an embedded video extracted from it and saved as an MP4 file. Let me know if this is something you can do, looking to get it done now within the hour.

...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 knowledge of data modeling - Proficient ...

...management system. Key Features: - Data Entry Forms: These should be user-friendly and designed for efficiency. - Reporting and Analysis Tools: I need to be able to easily track productivity and analyze task-related metrics. - Data Validation Rules: The system needs to ensure the accuracy of inputted data with stringent validation rules. Structure: The database should consist of 5-10 interlinked tables for comprehensive task tracking and management. Ideal skills and experience for this job would include: - Extensive experience with Access database design, specifically around task management systems. - Strong ability to translate user needs into functional system features. - An understanding of data reporting and analysis. A successful candidate should also demonstrate close ...

I'm looking for a gifted artist to create realistic watercolor portraits from a given photo(s) on a regular basis. I've provided links below to examples of such works. Key aspects of the project: - The typical turnaround time for such orders is 1-2 days. - You are required to produce artwork with the same quality and similar style (see provided examples). - Our processing time is limited, so timely communication and completion of tasks are crucial. Ideal Skills: - Proficiency in realistic digital art - Excellent attention to the detail - Ability to combine different photos to create the portrait Experience in creating similar works and portfolio showcasing such portraits will be required. Links: Artwork Examples:

I have a 1-page Excel spreadsheet with 9 text columns that need to be merged. I'm looking for someone who can start this job immediately and has experience in Excel data manipulation and formatting. Please only bid if you can do this job immediately and I will award and give you the file.

I need financial data from bloomberg or any other database for research.

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-sized project...

I'm in the process of designing an e-commerce website in Figma and I'm seeking a frontend developer who can transform this design into a fully functional and responsive website. Key Functionalities: - Shopping Cart: A seamless and user-friendly shopping cart integration is crucial for this project. The cart should allow for addition of items, editing of quantities, and a smooth checkout e...and a secure payment process. Ideal Skills and Experience: - Proficiency in frontend development - Experience with e-commerce website development - Knowledge of Figma or similar design tools - Experience in integrating payment gateways, especially PayPal and Stripe If you're confident in your ability to bring this Figma design to life and create a smooth e-commerce experience, I'd...

...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 part of the hours to be worked in the first weeks from 8:00PM- 2:00am UTC -3 (Brazil Time) later you can work on your time zone. Prerequisites: For the long term project the *STARTING* wage will be as stated below. 1) Accept initial hourly rate of U$5.00 2) If awarded, accept a...

...smaller .NET tasks all with 1 day sprints for you to become familiar with the software and then our main goal will be to integrate another B2B API for our MVNO. Initially we need part of the hours to be worked in the first weeks from 8:00PM- 2:00am UTC -3 (Brazil Time) later you can work on your time zone. If you are awarded the task we expect you to accept IMMEDIATELY and if the project is not accepted immediatly we will award it to another developer. To qualify you must be full stack and work PROFICIENTLY with gitlab and code in ., .NET ASP, WEB API + MS SQL. We also have woocommerce and have developed and will continue to develop plugins, so PHP and understanding of woocommerce plugins is a plus but not a necessity. Prerequisites: For the long term project the *...

I have a bulk of digital files that need to be accurately transcribed into a digital format. The files are all in English, so proficiency in English is necessary for this project. Ideal skills and experience include: - Proficient in English - Fast and accurate typing skills - Experience with data entry

I'm in need of a professional who can perfectly format my 100-page Word document. The document requires: - Adjusting the page layout - Ensuring consistent and appealing font styles and sizes are used throughout - Ensuring all tables are well-formatted and visually appealing In your application, please focus on showcasing your experience in Word document formatting. I don't need any graphics or images inserted into the document, just a clean and consistent format.

I'm looking for a Photoshop expert to help me with editing two photos for personal use. I need the following done: - Add text in the center of each photo - Remove unnecessary objects from the photos The skills required for this job include: - Proficiency in Photoshop - Attention to detail - Experience with photo editing - Creative thinking to make text additions look natural Please note that the purpose of these edits is for personal use so they need to be visually appealing and well executed. It will be necessary to ensure that the text additions blend seamlessly with the rest of the image.

I am seeking a creative and experienced graphic designer to craft a vibrant, standard size (3.5 x 2 inches), two-sided visiting card. The design of this card should highlight my business, convey vital information, and tell my brand story in a compelling manner. Key requirements include: - The inclusion of my name and contact information. - Use of logo and tagline in the design. - Bright and vibrant color scheme to align with the energetic aspects of my brand. Ideal candidates should have proficiency in .cdr file format and previous experience in business card design. Your bid should include a brief portfolio showcasing past works in business card design.

...mind: Languages - (Please free to suggest your own) Backend - PHP, jQuery, and SQL Frontend - HTML, CSS, and JavaScript For Real-time Demo/Example - Please sign up for and check their dashboard ########################################################## Social Login/Create account (Separate customer and Designer Login) ########################################################### Customer Dashboard Order Handling -------------- Past Orders Order Requirements (Quiz* and additional comments) Order Updates Order Delivery Date Order Tracking Order Payment Order Deliverables Order *Quiz ---------- Select service select size Select colours Select additional information Comments Attachments Submit Two way chat (communication) Your Profile Notification settings Payment Sett...

I have a simple text-based PDF file that I need to be converted into a Word document. The purpose of this conversion is to enable further editing and formatting. Key Requirements: - The PDF is straightforward, with no images or tables, just plain text. - The Word document should follow a standard business format, so no specific styling or custom style guide is needed. Ideal Skills and Experience: - Proficiency in typing and data entry - Familiarity with standard business document formats - Experience in PDF to Word conversion is a plus - Attention to detail to ensure accurate and error-free transcription

Se requiere un profesional que pueda diseñar un reporte en "SQL Server Report Builder". Este reporte, será modelo factura o pedido. Ya se cuenta con la consulta, y los parámetros de consulta (Fecha, desde - hasta), y también por número de documento (Desde - hasta).

I want to design a car wash, and I want to import the goods from China, but I do not know what is the method, the best quality, and the method of communication. I want boxes for electric tanks that are made of carbon fiber, I want washing materials, I want water pumps, vacuum cleaners, all cleaning tools, and some other things. Ideal Skills: - Proficiency in Chinese - Experience with online dispute resolution - Strong communication skills - Understanding of international commerce and refund procedures

I'm seeking an experienced developer to create an online script that can automate the conversion of CSV files. Script must be browser based and linux based. No preference on programming language. Source file will need to be uploaded to CSV converter, and script will sort data and rename columns based of pre-existing requirements. Once conversion is finished, download link generated to download updated CSV.

Necesito generar deshboard y gráficos en Power bi desde 4 bases de datos • 1 base de dato en postgresql corporativa en aws • 1 base de datos en sqlserver en un servidor local • Google Analytics • Zendesk Son aproximadamente 50 gráficos personalizados con los que necesitamos hacer algunos dashboard de gestión. Es importante dejar documentado el trabajo y respaldadas las consultas en sql. Indispensable: • Dominio de Power BI • Experiencia previa en la creación de paneles para ejecutivos • Capacidad para integrar datos de bases de datos Indicar los accesos requeridos y los requerimientos tecnológicos para desarrollar el proyecto

I am in need of a professional photographer who specializes in furniture photography. I have an apartment that I plan to host on Airbnb and require detailed, high-resolution photos of various furniture including chairs, tables, and sofas. This is a 1-2 rooms apartment, and it's essential to have photographs of every area, including the kitchen and bathroom. • Proven photography experience, especially in furniture photography • Ability to create attractive shots that capture the details • Experience in editing photos will be advantageous. • Responsibility to care for the furniture while working around it. • Proficient in effectively utilizing lighting to accentuate the aesthetics of the furniture. I want the potential Airbnb guests to see the beauty...

I'm looking to leverage Azure document intelligence prebuilt models and train models to extract data from a variety of tax and financial documents. The extracted data needs to be exported into a Google spreadsheet. Additionally, I need an interface for users to easily upload these documents. Key Requirements: - Extract data from various financial documents: primarily focusing on Expense reports, W-2 forms, credit card statements, 1099s, and annuities. - Extract specific data from credit card statements such as Transaction amounts, Merchant names, Transaction dates, and also the ability to convert currency and combine rows. - Extract specific data from bank statements like Account balances, Transaction descriptions, and Check numbers. Ideal Skills...

...the Products have already been done for reference but there are still around 500 products still needing to be done. The focus will be on using the Yoast Plugin to enhance Product titles. Increasing the word count of Product descriptions to around 230 words (sometimes creating from scratch using other sites as reference and or using AI to help), then creating search engine title and focus keywords and repairing URL structures if needed. If working through CSV is easier, a data export can be sent with relevant data columns. Key Responsibilities: - Enhancing product descriptions for improved SEO performance - Optimizing meta tags to drive more organic search traffic - Restructuring URLs to align with best SEO practices - Utilizing Yoast Plugin to ensure optimal SEO efficien...

PDF File converted to MS WORD File more than 300 pages Need ASAP

I'm searching for a skilled individual who can help me scrape data from a website. The data I'm interested in is text content and tables, specifically contact information. Ideal Skills: - Proficiency in web scraping tools - Strong experience with scraping text content and tables - Expertise in extracting specific information - Familiarity with structured data formats The contact information on the website is in a structured format. Your ability to navigate this and provide me with a clean, organized dataset will be crucial. Looking forward to collaborating with a detail-oriented and reliable professional. Attached is a sample format. The site is: Final file must contain all records for all schools on all pages

As the project owner, I'm looking to transform an image file of a 2D floor plan into a to-scale outline floor plan. For this project, the digitized floor plan should include room measurements. While I didn't specify a preferred software, utilizing a program adept at architectural design, such as AutoCAD or SketchUp, would be beneficial. The ideal freelancer would possess: - Proficiency in architectural drafting software - Experience transforming image files into digital floor plans - Attention to detail, specifically regarding accurate room measurements.

I'm searching for a professional who is proficient in SQL coding specifically for MySQL database design. PowerShell scripting or similar would also be beneficial. This is a basic level project taking existing Local government procedures and converting them into SQL based processes. An example of which would be creating a import procedure for traffic count data that is presented in a text format (example attached) Ideal Skills: - Experienced with MySQL Database Design - Well-versed in SQL coding - Ability to simplify complex instructions - PowerShell for anything not possible in SQL This project will demand creativity and intelligence to design procedures that simplify data entry processes. Please only bid if you can offer solutions according to the...

I am experiencing slow query processing and management issues with large tables in my MySQL database, primarily storing transaction data. I am seeking a DBA specialist to diagnose and resolve these bottlenecks and improve the overall performance of the system. Ideal Skills and Experience: - Proven experience in MySQL database administration and optimization - Knowledge of query execution plans and optimization techniques - Proficiency in managing databases with 10-50 tables - Experience in handling databases primarily housing transaction data Tasks include: - Investigating and diagnosing slow query performance - Optimizing handling of large tables - Implementing necessary changes to enhance overall database performance.

Hi Roman, If you remember, last year you did a project for me to show the list of participants of an event to me. I want to improve on that code and add some functionality and features to it. Would you be available? We can chat about the details, but basically, this is what I want: I have an Excel file with different sheets. For example, Founders, Advisors, Announcements, and Media. I want a code similar to the previous code (of course, more complicated) to read this Excel file and show the content of each sheet in a different format (as the amount of type of information is different). I will share an example of the Excel file with you. Are you available?

I'm searching for a talented DJ or music producer to combine elements from two songs and create a unique mellow remix. This project requires: - Emphasis on both lyrics and beats from each song. Your creativity in meshing these elements together is crucial. - The overall mood of the remix should be mellow. It is essential that the remix should not be too fast-paced or energetic. Ideal Skills and Experience: - Proficiency in using music production software - Knowledge in music theory - Experience in remixing and blending songs. Your creativity and interpretation of the two songs will make this project a success. Looking forward to hearing your unique spin on these tracks.

Need to copy a powerpoint presentation from a video all the slides theres about 30-40 slides some just images and some some text

I need a skilled Wordpress expert to address a migration issue I'm facing with my website. Here's what I need: - **Migration Issue:** The problem I'm experiencing is related to theme and plugin compatibility following the migration from a server running PHP 7.2.4 where the site worked to a server running PHP 8.2. The front end of the site works but now access to the back end gives the error "There has been a critical error on this website. Learn more about troubleshooting WordPress." I need someone to correct the code so that it works correctly. I believe that the issue may be connected to WPBakery To excel in this project, you should be highly experienced in Wordpress, with a deep understanding of PHP, theme and plugin compatibility issues. Your abil...

I'm looking for a skilled professional to create a Web Assembly prototype, , using a small Delphi application that primarily showcases an interactive user interface. The aim is to target the prototype for web browsers. Key Requirements: - Creation of a Web Assembly prototype utilizing a Delphi application. - Focus on showcasing a simple interactive user interface The Prototype: - The user interface for the prototype is envisioned to be simple, consisting of basic elements. - The primary focus should be on the seamless integration of the Delphi application's functionality into a web browser environment.

I need a data studio expert to create a comprehensive report for my Google Ads and meta data. The report should focus on: - Click-through rate - Conversion rate - Cost per click - Conversions per key word The repo...comprehensive report for my Google Ads and meta data. The report should focus on: - Click-through rate - Conversion rate - Cost per click - Conversions per key word The report should cover the last 30 days. I prefer a report that represents data in tables and numbers rather than through charts and graphs. Skills required: - Proficiency in Google Data Studio - Strong understanding of Google Ads and meta data - Ability to work with large data sets and visualize information effectively in tables and numbers - Strong analytical skills to draw insights fro...

...credibility. Key details to include: - Call to action: Call or Text for free no-obligation cash offer - Contact Information - Benefits of Selling to an Investor. The design should also be centered around promoting our unique selling proposition - 'We Buy Houses - Sell As-Is For Cash.' The aim is to make this stand out and appeal to potential customers. To enhance trust and credibility, testimonials from previous clients should also be creatively incorporated into the design. Ideal skills and Experience: - Proven experience in graphic design, preferably for real estate - Strong portfolio of designs - Creativity and innovative ideas - Exceptional attention to detail -Familiarity with creating designs that generate leads and convey trust. Let's create a postca...

...project is to create a nodeJS program that will retrieve an xls file from an email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. Each line in the xls file corresponds to a delivery. The file has 15 colu...

I need assistance with scraping data from a website and delivering it in an Excel file. The specifics of the project are as follows: I am looking for a person who will conduct scraping sessions for our business on a regular basis. Desired skills are knowledge of screen-scraper software, sql, Someone with Python knowledge will be better. Willing to follow instructions. Not cramped up with other jobs or other side hustles. Need to have solid internet connection. Expected work takes 5-10 hours per week, once fully trained. Must be responsible. Able to accept PayPal. - The source of the data is a website. This means the freelancer needs to have experience in web scraping. - The data should be delivered in an Excel file. Proficiency in handling and formatting data into Excel ...

I'm looking for an expert to take the text from my Word document and incorporate it into my Canva slides. The slides are for a presentation, so it's crucial that the information is presented clearly and with a professional touch. Key Tasks: - Transferring text from a Word document to Canva slides - Ensuring all text is appropriately sized, formatted and positioned within each slide - Adapting the text to fit the existing layout and design of the slides - Keeping the information clear and engaging for a presentation audience Ideal Skills and Experience: - Proficiency with Canva - Excellent attention to detail - Prior experience with creating or modifying presentations - Ability to adapt existing layouts to fit new content - Strong communication skills to understan...

I'm seeking an Airtable expert to assist me with a number of tasks, including data entry and organization, building custom workflows, and creating advanced formulas. Ideal candidates should have: - Previous experien...building custom workflows, and creating advanced formulas. Ideal candidates should have: - Previous experience working with Airtable, including data entry and organization, workflow creation, and complex formula design - A strong understanding of how to make the most of the tool, including its integrations and automations Please note that while my exact requirements in terms of the number of tables and views in my Airtable base, as well as specific integrations I need, have not been stated, I expect the freelancer to be able to adapt to my needs and work in a...

I'm in need of a skilled designer to create a logo for my company that combines text and icon elements. The design should be both elegant and sophisticated. The final product should convey a sense of professionalism and reliability. Ideal skills for this project include: - Experience in logo design - Ability to combine text and icon elements effectively - Understanding of elegant, sophisticated design aesthetics - Ability to reflect professionalism and reliability through design I look forward to seeing your creative solutions.

Data Specialist: The Data Specialist is responsible for pr...information that is in databases, organizing and assembling the information so that teams can make decisions using data. Responsabilities: > Access database. > Create dashboards and analysis according to the demand of the business areas. > Update and automate dashboards that need frequent updating. > Provide suggestions of improvements in business areas. Requirements: > Mandarim is a must > SQL > Office Package > Database usage At Shein, we believe that diversity is the force that drives innovation. We are committed to creating an environment where all voices are heard, valued and respected. All our vacancies are inclusive for people with disabilities, women, black people, LGBTQIAPN+ com...

...to: - Automatically extract specific information from a variety of documents including Word, PDF files, Excel Spreadsheets, and Scanned documents - Thoroughly analyze extracted content including text, tables, charts, and images for compliance and precision - Automatically generate comprehensive reports based on extracted information for easy reference For this task, proficiencies in AI, Machine Learning, ChatGPT, and automation are necessary. Likewise, experience in OCR technology for processing scanned documents will be valuable. Not only should the candidate be detail-oriented - they should also be adept at debugging and ensuring the system seamlessly integrates with our existing customer service processes. The above was generated from Freelancer. Below is mor...

I need a skilled professional who's an expert in Azure Data Factory (ADF) development, SQL, Power BI, and ADF monitoring. Key Tasks: - Creating data pipelines - Building data transformation workflows - Integrating with SQL databases Power BI Usage: - Visualizing data through interactive dashboards - Creating data reports and analytics - Real-time monitoring and alerts ADF Monitoring: - Tracking data pipeline performance - Monitoring data integration processes - Setting up alerts and notifications for job failures. Ideal Skills and Experience: - Expertise in Azure Data Factory (ADF) development - Proficiency in SQL, Power BI, and data visualization - Strong background in monitoring ADF performance - Experience setting up real-time alerts and notifications - Pr...

I'm seeking an independent ASP.NET developer based in India with at least 5 years of experience, strong C# programming skills, and familiarity with SQL Server and Asp.net core. Your English skills will be crucial as direct communication with me is required. Key Responsibilities: - Develop a robust business management system leveraging ASP.NET - Implement user authentication and authorization features - Integrate appropriate APIs to enhance system functionality Ideal Candidate: - Minimum 5 years experience in ASP.NET development - Proficient in C# programming and SQL Server - Familiarity with Asp.net core - Experience in developing business management systems preferred - Strong communication skills for client call Please note that this project is only open to Indian-ba...

- Size: 36" high by 48" wide - Plotting and vector cut line - 2 files one with dimensions displayed other with artwork and cut contour lines. - Should be able to change color of each element in file with just click and fill. - Text if there should be editable (words, font and color)

I need someone who knows about monorepo and angular , the application was in angular 10 and I transferred it to angular 17 (dependencies, code, etc.) now it seems to compile but it throws an error NG0908 .I just need them to make me work (run well in ngserve). Please write ragnar to see you read the post.

have anyone can help me to install the Laravel system which buy from themeforest, thanks i will provide the domain and also the login of the hosting, thanks

I have an existing Laravel-based ecommerce application that requires a series of modifications and additions. Key Tasks: - **New Tables & Conditions**: I'm looking to add several new tables and conditions to the application. Skills & Experience: - **Laravel Proficiency**: I'm seeking a seasoned Laravel programmer who has extensive experience with ecommerce applications. The ideal candidate should be highly proficient in Laravel framework and comfortable creating new tables and conditions within the application. - **Database Management**: A solid grasp on database management is crucial to successfully add and integrate these new tables. Experience with MySQL or other relational databases is desirable.