Code project xls sql jobs
I need a Pyspark code that reads join rules from a txt file and applies them in the main program. The joins will be based on multiple columns, with the rules formatted as column names with conditions. The code should only implement inner joins. Ideal candidates should have comprehensive experience in Pyspark, understand how to manipulate data frames, and can write clean, efficient code.
We already have a MySQL cursor with a loop set up to fetch values and perform certain calculations. We need an experienced MySQL deve...different table using simple IF conditions based on the calculated values. • Ensure the solution is optimized for minimal database overhead and runs as efficiently as possible. • Deliver the source code with minimal documentation so that I can easily understand where the logic has been programmed and which calculations have been added. Skills Required: • Strong proficiency in MySQL, particularly with cursors and loops. • Ability to work with provided simple formulas and integrate them into the cursor logic. • Expertise in optimizing SQL queries and minimizing database load for performance. Project Timeli...
I'm looking for a skilled database programmer to create a stored procedure for data retrieval across five tables. This procedure should handle complex joins and maintain foreign key relationships. Key Requirem...skilled database programmer to create a stored procedure for data retrieval across five tables. This procedure should handle complex joins and maintain foreign key relationships. Key Requirements: - Design a stored procedure primarily for data retrieval. - Proficient in managing joins across multiple tables. - Understands and can maintain foreign key relationships. Ideal Skills: - Proficiency in SQL and experience with stored procedures. - Strong understanding of database management and relational databases. - Excellent problem-solving skills to handle complex data r...
I'm looking for a VBA developer who can create a code for my Microsoft Excel. When I copy/cut a cell, the previous 5 cells should be blocked from being copied/cut as well. This restriction should apply only to the active worksheet. Ideal Skills: - Proficient in VBA programming - Deep understanding of Microsoft Excel - Previous experience in creating Excel macros
...Store raw data temporarily in Amazon S3. Data Parsing Clean and structure raw data for further processing. Ensure data validity and store parsed data in S3. Data Transformation Enrich and reshape parsed data for analysis or database upload. Store intermediate results in S3 for staging. Data Upload to SQL Database Save transformed data into Amazon RDS (PostgreSQL/MySQL) with optimized database inserts. Ensure data integrity and performance. Data Analysis and SQL Transformations Execute SQL procedures and queries in RDS for additional analysis and derived insights. Store final results in the database for website access. RESTful API Development Build a secure RESTful API using AWS API Gateway and Lambda to provide real-time data to the website. Optimize database q...
I have a Xamarin code for iOS and Android apps, written in 2020. I have installed visual studio 2022 on my Mac. when i try to run the project, it is throwing errors as it is 2020 code. Need a developer who can fix the environment issues and generate iOS and Android app builds.
I need a Python developer to integrate a Telegram bot with Python code that will execute predefined terminal commands. The system should take messages which are broadcasted to the bot and execute the corresponding command. Key Requirements: - Python programming skills - Experience with Telegram bot development - Familiarity with terminal commands - Knowledge of MySQL for querying The primary goal of this project is to automate the execution of specific tasks via the Telegram bot. The user will interact with the system by sending MySQL queries, which the bot will interpret and respond to. The ideal freelancer for this project should be able to help me with the following: - Executing predefined commands - Using MySQL queries to trigger these commands - Ensuring the sys...
Custom PHP Script for Batch Code Update in MySQL Database I am looking for an experienced PHP developer to create a simple and effective script that interacts with a MySQL database for bulk code updates. Requirements: Input Handling: The script should accept a list of codes through a text box, where each code will be pasted on a new line. Database Interaction: For each code input, the script must locate the corresponding record in the MySQL database, where the codes are stored in individual rows. Value Update: Upon finding a match, the script should update the value of that code with a number specified in a second text box. Error Handling: If the script cannot find a code in the database, it should skip that code and display a warning messa...
...All components from the old site must be retained and linked to the same DB, but with a new identity. - The design must be compatible with the Figma design and implemented using .NET framework 8, SQL server DB, JavaScript, and AJAX (in search). - Two language versions are required: Arabic and English. - All website functionalities need to remain unchanged, including user authentication, data reporting, real-time updates, and all existing links and data. Some links should be editable from the control panel to open external links ; So you need to use same control panel (I Well provide old source code). - Integration of social media into the new version. - You are responsible for publish website on our server (on Google cloud) - We need guides to SEO Ideal Skills: - Strong U...
I'm looking for a proficient Terraform developer to create a script for Google Cloud. We need the script to create these items 1. networking 2. GKE cluster with one node 3. permanent volume and claim for GKE 4. Postgres SQL service - needs to be accessible from GKE 5. API Gateway - if API URL is /example1 > run a lambda function - otherwise forward API request to /endpoint/{incoming URL) (a service running in GKE) 6. IAM Role Binding for Cluster Access
Hi, there is an inbuilt indicator in the TradingView platform as one of their technical indicators called Elliott Wave Chart Pattern. I would like to retrieve the source code for it, but I believe it may be written in Javascript or a different language to PineScript the code is not visible. I would like the source code provided for me and it should work in exactly the same way as the original indicator. As long as it provides the same wave count I don't mind how this is achieved. **** I am only interested in this exact same indicator called 'Elliott Wave Chart Pattern' offered by TradingView **** I will require demonstration that you have replicated it exactly before payment is made. Please only bid if you are sure you can achieve this. Thank you.
I require a professional-grade, data-focused dashboard that can visualize plots and display LLM (Large Language Model) responses. i want the dashboard built in streamlit Ideal Skills and Experience: - Proficient in Python with a strong understanding of asynchronous programming. - Experienced in creating professional dashboards, preferably with a focus on data. - Highly skilled in using Plotly for data visualization. - Previous experience with real-time data displays is a plus. Please only apply if you are willing to complete the job for the stated price. Note that you will also need to sign an Intellectual Property (IP) agreement.
I'm in urgent need of a cyber security spe...security specialist who can perform thorough penetration testing on my React web application. The primary goal is to identify any potential security vulnerabilities, particularly: - Cross-Site Scripting (XSS) - SQL Injection - Cross-Site Request Forgery (CSRF) Your expertise in assessing these specific types of vulnerabilities will be crucial. The ideal candidate would also have experience in Quality Assurance, particularly with automated testing tools such as Selenium and Cypress. Your role will not only involve identifying security vulnerabilities, but also ensuring the overall code quality through automated testing. Please include in your proposal your relevant experience and any examples of previous work that may be ...
I have a substantial amount of Python code that needs modification for asynchronous execution. This code consists of numerous functions. Furthermore, I require a professional-grade, data-focused dashboard that can visualize plots and display LLM (Large Language Model) responses. Key Requirements: - Convert existing Python functions into asynchronous ones. - Design and build a data-focused dashboard. - Utilize Plotly for visualizations, as this is the library currently in use. - Ensure the dashboard can handle real-time data updates. Ideal Skills and Experience: - Proficient in Python with a strong understanding of asynchronous programming. - Experienced in creating professional dashboards, preferably with a focus on data. - Highly skilled in using Plotly for data visualizat...
I need a freelancer to set up a daily backup of my Microsoft SQL Server database from a dedicated Windows server to S3 AWS Storage. The backup files need to be compressed. Ideal Skills and Experience: - Proficiency in Microsoft SQL Server - Experience with AWS S3 - Knowledge of Windows Server - SQL database management - Data compression techniques
I'm in need of a Kotlin code base APK that has been fully configured for end-to-end (E2E) use. Two source code full module is available. Key Requirements: - Need both module APK with full e2e working. The code is already ready just need to build apk from local build. Also firebase setup detatils with documentation Buget is only 500
I'm looking for a professional code reviewer to check the quality of my Java and Python codes. The primary goal is to ensure maintainability. I also have concerns regarding the scalability of the code. Key Tasks: - Assess for code smells - Identify unused classes/variables - Evaluate the code's scalability Ideal Skills and Experience: - Proficient in Java and Python - Experience with static code analysis - Strong focus on code maintainability - Understanding of scalability concerns
I need an expert to update my iOS app Carplay improvement. Carplay works but there are some problems. i need standalone working support for carplay, when user dont open app on device, carplay cant fetch content(radio) and cant play. The project entails: - Improving carplay - Fixing issues - Updating deprecated APIs - Updating deprecated codes It is crucial that you have extensive experience with iOS development and Carplay integration. Familiarity with identifying and rectifying connectivity issues within Carplay is highly desirable. I look forward to your proposal.
I'm looking for a skilled Snowflake developer with extensive experience in data warehousing. The project involves integrating various data sources, primarily AWS S3 and SQL databases, with Snowflake. Key Responsibilities: - Data Warehousing: You'll be primarily focusing on the data warehousing aspect of Snowflake. - Data Integration: Integrating AWS S3, SQL databases, DBT, and Snowpark with Snowflake. - Data Transformation: Your main use of dbt will be for data transformation. Ideal Skills: - Proficient in Snowflake, dbt, and AWS. - Experience with data warehousing and integration. - Hands-on experience with live projects using these technologies. - Strong understanding of data transformation processes. Successful candidates will have previous experience ...
I need a Python Data Analyst skilled in processing data from an SQL database and conducting descriptive statistics.
I have a simple wood part that has been modelled in SolidWorks, I need someone to process it in Powermill, and produce the G-code for a 5-axis lathe. Your tasks will include: - Utilizing the provided SolidWorks part and example Powermill project file to guide you. - Prioritizing tool path optimization within the G-code. Ideal candidates for this project should possess: - Advanced SolidWorks and Powermill skills. - Experience with creating G-code for 5-axis lathes. - Understanding of wood as a primary material. Please be prepared to demonstrate past projects involving similar tasks.
...maintaining the business’s web-based systems. -- Work on web development projects using Python and associated tools. -- Ensure code is scalable, maintainable, and efficient. Required Skills: -- Strong experience in Python (3-5 years). -- Proficient with Selenium WebDriver for web scraping and automation. -- Experience with BeautifulSoup, Requests, Scrapy, and other web scraping frameworks. -- Solid understanding of Databases (SQL/NoSQL) and integrating them with web applications. -- Experience in web development (preferably with frameworks like Django or Flask). -- Strong knowledge of Flutter for mobile development. -- Ability to work independently and deliver quality code within deadlines. Additional Requirements: -- Proven experience of 3-5 years in Python...
I need assistance with manual data entry into an SQL database. The project involves working with database entries, so experience with SQL and data handling is essential. Ideal Skills: - Proficient in SQL - Manual data entry experience - Attention to detail - Data handling skills - Able to work independently and meet deadlines
I'm looking for an expert in HTML code modification to enhance my landing page. The modifications should be aimed at improving the overall user experience.
I need to modify the HTML code of my landing page. This will involve changing text content, visual design elements, and enhancing functionality. Ideal Skills: - Strong HTML skills - Experience in web design - Understanding of web functionality You will need to be able to understand and implement changes based on visual design updates and text content alterations.
...must be responsive, agile, and fast work deliver to avoid our assumption that you no longer working on this project. - Full of integrities : Trustworthy, independence, responsible, firmed-straightforward, modest-humble, care-emphatetically, fair, and hard worker. - Willing to learn new things. I am looking for someone who can understand the intricacies of data processing and can help ease the burden of manual tasks. The goal is to streamline our operations and enhance productivity. -- Basically, we have a data processing project which is going to be presented into our new website. We need a backend Python Developer whom can process data in our Google sheet then be dumped into SQL, eventually going to be presented into our new website. Therefore, t...
I'm seeking a freelancer with robust XLS and data analysis skills who can help me create a PPT presentation based on customer feedback analysis. Key Tasks: - Analyze customer feedback data to identify trends in customer satisfaction. - Pinpoint the most common complaints from the feedback. - Extract suggestions for improvement from the customer feedback. - Create a compelling and clear presentation from the analysis. Ideal Skills: - Proficient in Excel for data analysis. - Experienced in creating presentations in PowerPoint. - Strong analytical skills to interpret customer feedback data. - Ability to present data in a clear and engaging manner.
We have 2 SQL databases. A source database and a target database that have completely different structures (tables, field names/types and relations). We're doing some migration planning from source to target and need some consulting advice on how to best map tables and fields for ETL migration. We are looking for a solution that uses AI and/or ML to avoid doing this all manually the schema mapping. Please put "SCHEMA123" at the start of your proposal so we can filter out automated responses. Please list any details of your experience in doing a project like this. Thanks!
I'm looking for a seasoned professional with advanced knowledge in SQL database architecture. The primary task will be designing a new database. Ideal Skills and Experience: - Extensive experience with SQL - Proven track record in database design - Ability to understand and meet project-specific requirements - Strong problem-solving skills - Excellent attention to detail
Title: Development of a Personalized Property Rating System Description: We are looking for an experienced developer to help us create a system that can generate personalized property ratings. The goal is to integrate various external dat...existing CRM platform. • Provide ongoing support and maintenance. • Work independently and ensure the system runs with minimal manual intervention. Technical Requirements: • Experience with API integrations and data processing. • Familiarity with CRM systems and integration. • Strong skills in data processing technologies (e.g., Python, SQL). • Ability to generate reports and analytics based on property data. If you are interested in this project, please send us your resume and relevant experience. W...
Laravel PHP Developer for NFC Card & QR Code Payment System [ FrontEnd and Login Page ready ] We are seeking an experienced Laravel PHP Developer to build a web-based NFC Card & QR Code Payment System with the following features: Key Responsibilities: Superadmin Role Manage all Admins/multiple Businesses and Users. Oversee NFC cards, transactions, cashout requests, cash deposit requests, and virtual credit management (loading credits for users). Admin Role (for Businesses) Recharge NFC cards and handle card top-ups. Manage virtual credit received from the Superadmin. Download own business QR code Create and manage "Cashier" roles within their business. Handle deposit and cashout reque...
...All components from the old site must be retained and linked to the same DB, but with a new identity. - The design must be compatible with the Figma design and implemented using .NET framework 8, SQL server DB, JavaScript, and AJAX (in search). - Two language versions are required: Arabic and English. - All website functionalities need to remain unchanged, including user authentication, data reporting, real-time updates, and all existing links and data. Some links should be editable from the control panel to open external links ; So you need to use same control panel (I Well provide old source code). - Integration of social media into the new version. - You are responsible for publish website on our server (on Google cloud) - We need guides to SEO Ideal Skills: - Strong U...
I'm seeking a seasoned Ruby on Rails developer for the maintenance and updates of an existing Business Services web application. The system is designed to manage client details, documents, and operations. Key Responsibilities: - Regular main...seeking a seasoned Ruby on Rails developer for the maintenance and updates of an existing Business Services web application. The system is designed to manage client details, documents, and operations. Key Responsibilities: - Regular maintenance and updates of the web application - Ensuring system efficiency and functionality Ideal Skills: - Proficiency in Ruby On Rails - Experience with Docker and SQL - Previous work on Business Services systems Please note, the selected developer must be contactable and able to work during UK standar...
I'm looking for an experienced SQL Server professional to set up log shipping for disaster recovery purposes. This will primarily involve transactional data, and log backups need to be taken and shipped every 5 minutes. Ideal skills and experience: - Extensive knowledge of SQL Server - Proven experience with log shipping - Strong understanding of disaster recovery strategies - Familiarity with handling transactional data - Ability to set up frequent log backups (every 5 minutes)
...looking for a unique QR code design incorporating Islamic calligraphy in a green and gold color scheme although I am also open to other color schemes. This QR code will link to a website about the Quran. Your proposal should include: 1. The cost for developing this original QR code design. 2. The cost for creating 6350 bulk QR codes based on this design, each linked to a unique URL. 3. Assurance that these codes will be permanent with no ongoing fees. 4. The ability to change the URL of the codes post generation if needed. 5. Provision of scanning reports upon request/ability to obtain these reports myself 6. The timeframe for designing the original QR code and generating the bulk codes. 7. All source files Ideal skills for this project include graph...
Our company is in search of a dedicated Full Stack Developer to join our team full-time. We specialize in web and mobile application development, and we need someone with a strong background in this area to help us create top-notch applications targeting both desktop and mobile users. Key Skills & Experience: - Proficiency in Laravel, Tailwind, Livewire , Filament, PHP, JavaScript, and SQL Database. - Experience with MVC Frameworks. - Creative UI development skills. - Strong understanding of user experience considerations including easy navigation, fast load times, and aesthetic design. - Previous work as a UI designer is a plus. - Familiarity with the Livewire Laravel package. The selected developer will enjoy a three-year fixed contract and will be part of the company payrol...
I'm in need of a skilled freelancer with extensive experience in Zoho CRM and database management to synchronize our Zoho CRM with our database. Key Responsibilities: 1. Data Update & Cleanup: - Align our CRM ... - Ensure the script is capable of handling incremental updates and can operate on a set schedule. 3. Documentation & Automation: - Create clear and concise documentation detailing the cleanup and synchronization processes. - Automate the sync script for regular execution (e.g., hourly via crontab). Ideal Skills: - Extensive experience with Zoho CRM and its API. - High proficiency in SQL and Python. - Strong familiarity with data cleaning and automation tools. Please reach out if you're interested and share examples of similar projects yo...
I have an existing working TensorFlow code that requires modifications to enhance training performance and improve model test metric. I do not need a new code from scratch, but rather an expert who can make targeted changes to my existing code and run it on a gpu. I need a fully trained model within 2-3 days. My model has about half a million parameters and any changes to Network architecture must ensure the parameter count stays within one million. My test metric is miou and I want to achieve 80% while my current model gives me roughly 40%. Besides that, the final model should run on a CPU. Gpu is only required to make training faster. Key Requirements: - Access to a GPU and expertise in utilizing it for deep learning tasks - Proven experience with training deep lear...
I'm looking for a Python expert who can help analyze our customer data. - The primary goal of this project is to derive insights from our customer data to drive business decisions. - The data is stored in databases, so experience with SQL and database management is a plus. - A strong background in data analysis and Python is essential for this project. Please include your relevant experience and examples of similar projects you've completed in your proposal.
I'm looking for a professional developer who can create a network security API similar to Burp Suite. This API should primarily focus on vulnerability scanning, specifically for SQL injection and Host header injection. It should provide detailed technical reports on the vulnerabilities it discovers. Ideal Skills and Experience: - Proficient in API development - Extensive knowledge in network security - Experienced in vulnerability scanning - Familiar with SQL injection and Host header injection - Capable of generating detailed technical reports
...Token management needs What We're Building: ┌─────────────┐ ┌──────────────┐ ┌────────────┐ │ Beds24 │────►│ Business │────►│ Data │ │ │ │ Logic │ │ Layer │ └─────────────┘ └──────────────┘ └────────────┘ Building a robust data layer and business logic system using serverless functions (Cloudflare Workers/Supabase Functions) and SQL database (D1/PostgreSQL). 1. Modern Data Layer - Complete booking management - Change history tracking - Price and availability tracking - Full audit capability 2. Sync System - Reliable data synchronization - Error handling and recovery - Bidirectional updates - Performance optimization Technical Stack: - Serverless Functions (Cloudflare Workers or S...
I'm looking for a freelancer who can thoughtfully answer 5 questions on Stack Overflow. The answers should link back to a notebook on Scribbler, which contains relevant code snippets. This project is focused on: - Programming languages - Development tools - Javascript Your answers should not only provide assistance to the original poster, but also drive traffic to the Scribbler notebook, which is intended to showcase example usages of different code snippets. Ideal candidates for this project should have: - Strong understanding of programming languages and development tools, particularly Javascript. - Experience with Stack Overflow and understanding of its community norms. - Ability to write clear, helpful, and engaging responses. - Familiarity with Scri...
I need a freelancer to make minor adjustments to my current name card design. Specific Tasks: - Text: Update with new contact information - Logo: Modify the existing logo on the card - QR Code: Incorporate a QR code that links to my contact details - Additional: Small adjustments to the current design elements Ideal candidate should have a background in graphic design, and experience with creating and integrating QR codes into print materials.
I'm in need of a Tally Prime code specifically designed to assist with managing product descriptions. Key features: - The code should facilitate the handling of product descriptions efficiently, allowing for easy navigation and updates as needed. Ideally, the freelancer should: - Have extensive experience with Tally Prime and coding for it. - Understand inventory management and product description systems. - Be able to provide a trial TCP for testing the code before final delivery. Please note that I will need to be able to check the functionality of the code using a trial TCP before final acceptance.
I'm looking for a skilled data analyst and Python programmer to create a code in Jupyter Notebook for analyzing data from Excel files. The project involves: - Primarily focusing on data analysis - Utilizing Pandas and NumPy libraries Ideal candidates should have: - Extensive experience with data analysis and Python programming - Proficiency in using Pandas and NumPy - Ability to work with Excel files - Familiarity with Jupyter Notebook Please include in your bid examples of similar projects you've completed. You are required to write the necessary program and create an effective presentation describing: The military spending of at least the top 10 nations (in military spending) Compare the data to that country’s GDP, Compare the data to the overall mili...
I'm in need of an experienced embedded systems developer to help troubleshoot and debug some code running on a TI CC1352P micro-controller. The debugger will need to have a strong background in C/C++ and familiarity with TI Code Composer Studio. Given the complexity of the project, I'm looking for someone based in Ontario, Canada, who can potentially offer in-person assistance if necessary. Ideal Skills and Experience: - Proficient in C/C++ - Extensive experience with TI Code Composer Studio - Familiarity with TI CC1352P microcontroller - Embedded systems development background - knowledge of OpenThread Protocol - wireless thermostats (based on TI CC1352P micro-controller) creating Mesh Network (OpenThread Protocol) - Based in Ontario, Canada
We are migrating data from our current ERP system (that is stored in an SQL database) to Microsoft Dynamics Business Central Cloud. The source database structures is different than Business Central. We have been able to reverse engineer both the databases and create ERD models and DDL scripts. Also we know how to create Dynamics APIs and use AL to interact with Dynamics. We are looking some consulting advice on how best migrate the data into dynamics. For example looking for ideas how to best table and field match, what software tools to use, best proccess etc for this ETL project. Please describe any experience you have with ETL/migrating data between different systems. Please add the word DYMANICS123 to the start of your proposal so we can weed out automated responses. ...
