Sql code extract xls filePekerjaan

I'm seeking a seasoned epidemiologist or data analyst who can write R code for a project utilizing health records. The ideal candidate should have: - Expertise in epidemiology or data analysis - Proficient R programming skills - Experience working with health datasets The code should have basic comments for clarity. Detailed documentation is not necessary, but the comments should enable a basic understanding of the code's functionality.

I'm looking for a talented developer with robust experience in PHP and SQL to create custom plugins and and features for my SMF 2.0 forum. The forum uses PLAIN PHP. NO framework! Ideal Skills: - Proficient in PHP and SQL - Extensive experience with SMF 2.0 - Previous work in developing custom plugins or mods for forums - Experience with HTML and CSS for front-end customizations - Able to use Ajax for real-time dynamic updates Please see the attached detailed worksheet for the requirements

...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, the Python developer needs to be familiar with Google sheet API, Django framework API, and scrapping for our data processing. Data synchronization should occur in real-time. Our budget is $3/hour for maintaining the codes and website $5/fix rate for replicating or making a new code, but for a specific code, if it's not that easy since you need to crawl from third party API etc, you can negotiate it. You can also negotiate after our website is finished and when we eventually we st...

...learning models to analyze large datasets and derive actionable insights Develop and integrate machine learning algorithms into production systems, ensuring scalability and performance Collaborate with data scientists, software engineers, and other stakeholders to define system requirements, data pipelines, and performance metrics Utilize big data tools and frameworks to process, analyze, and extract insights from large datasets in various domains Continuously improve model performance through experimentation, hyperparameter tuning, and model evaluation Stay updated with the latest AI and machine learning research trends to apply cutting-edge technologies and techniques. Implement best practices in coding, version control, and continuous integration for AI/ML projects. Required...

...learning models to analyze large datasets and derive actionable insights Develop and integrate machine learning algorithms into production systems, ensuring scalability and performance Collaborate with data scientists, software engineers, and other stakeholders to define system requirements, data pipelines, and performance metrics Utilize big data tools and frameworks to process, analyze, and extract insights from large datasets in various domains Continuously improve model performance through experimentation, hyperparameter tuning, and model evaluation Stay updated with the latest AI and machine learning research trends to apply cutting-edge technologies and techniques. Implement best practices in coding, version control, and continuous integration for AI/ML projects. Required...

I'm seeking a professional who can extract multiple images from an architectural .exe file. The images should showcase residential homes from various viewpoints: front, side, and aerial. The purpose of these images is to promote our development project to potential buyers and investors. Key Requirements: - Ability to work with .exe files and architectural software - Extract images from specified viewpoints: front, side, and aerial - Create visuals with basic outlines without any surrounding elements - Deliver in a format suitable for promotional use Ideal Skills: - Proficiency in architectural design software - Experience in creating promotional visuals from architectural designs - Attention to detail to ensure images are clear and professional The final images...

eq and compress a file approximately 1.5 minutes.

...perfil que cumpla con los siguientes requisitos: - Experiencia en desarrollo con Python. - Manejo avanzado de APIs REST: Habilidad para consumir y construir servicios RESTful, interpretar documentación técnica y manejar autenticaciones (OAuth, API Keys). - Conocimientos en manejo de archivos CSV: Importación/exportación de datos y tratamiento eficiente de ficheros. - Experiencia con bases de datos SQL: Conexión, consultas y gestión de datos. - Familiaridad con herramientas de versionado como Git. - Capacidad para documentar código y procesos de forma clara. Plus (No indispensable, pero bien valorado) - Experiencia previa trabajando con integraciones de marketplaces como Amazon, eBay, Shopify, Mercado Libre, entre otros. - Experie...

...issues include (but are not limited to): - Name, needs split between first and last so that we can email using first name only. - connection between contacts and projects is not working properly in some cases, it should connect the contacts between boards. - Deals are not connecting automatically with contacts/accounts/etc - The rep should be assigned to the person who creates the new deal on the SQL board, it does not. That rep should also be assigned/matched on all other boards for that client/deal/contact person. Problem is that because they get assigned from another - we want to change deal name to an ID number (or add a new column for this) - we need to make contacts and accounts required fields, they must be filled out and connected across boards. - is there a way to ...

...1) ke každému (skoro každému) HEADERS řádku bude vytvořen v XLSX nový List, jehož název bude zhruba odpovídat prvnímu stringu v řádku Headers, celkem tedy bude mít XLSX cca 20 listů. Do takto vytvořených jednotlivých Listů je třeba nalít data z jednotlivých datových řádků csv. Vkládaná data do XLSX je nutno precizně naformátovat dle druhu vkládaných dat (čísla, datumy, atd.) a přiměřeným způsobem XLS (šířka sloupců, grafická úprava, atd.) upravit. Vše z Powershellu, ne ručně. Poskytnu: kompletní zdrojový csv a hrubý návrh XLSX (bude mít předpřipravené ...

Se debe tener para hoy Presupuesto 100 dólares Cuento con un programa de escritorio desasollador en visual studio .Net que genera xml, cuento con certificado digital y claves para poder generar xml, firmarlo y enviarlo a sunat . Utiliza sql server. Xml lo tengo estructurado con los parámetros requeridos por sunat.

I am seeking a skilled Python developer to enhance and expand the functionality of my existing codebase for a psychology experiment. The primary objectives are to optimize the current code, implement new features, and improve usability. Project Scope: The most recent version of the code is available here: Key Tasks: Code Refinement: Rationalise and clean up the existing code. Remove all components related to eye tracking. Data Processing Enhancement: Improve data handling to allow easy access to recorded information. Include functionality to evaluate whether participant selections are correct. Experiment Customization: Develop features to easily configure experiment variations, including: Number of iterations each participant experiences. Timing an...

I need a developer to create a straightforward, modern yet minimalistic FrontEnd similar to eBay, connecting to my existing backend. It should be designed for a standard 16:9 PC screen, utilizing the following technologies: - Blazor .Net 8 - MS Sql - React.js - Laravel Core functionalities should include: - User login and registration - Product listing and search The design should be: - Modern and minimalistic Interactivity should be limited to: - Slide-in menus Ideal candidates should have significant experience with Blazor .Net 8 and Bootstrap v5, and a strong understanding of modern, minimalistic design principles. They should also be able to implement simple, user-friendly interactive elements. The frontend should use a dark theme. The target completion time for this proje...

Stage 1: Add columns and readjust VBA code

I need information on all the stocks dual listed on NYSE and LSE stock exchange currently in the form of a spreadsheet with high volumes and market cap. Preferably someone with an API that can extract information. DO NOT BID IF YOU DO NOT UNDERSTAND STOCK MARKET!

I'm in need of a web scraping professional to extract all URLs and titles from a particular website. The task is a one-time project. Ideal Skills: - Web Scraping - Data Collection - Proficiency in tools like Python, BeautifulSoup, Scrapy, etc. - Familiarity with different types of websites (e-commerce, blogs, news sites, etc.)

I need a database constructed. It needs automations…. can be no code or sql… there 4 types of users… staff admin clients staff Town olanner staff DA Manager See notes below:- Clients – only have invited access to onboard themselves…. Site Address Name of Entity Do they own the site or applicant Entity address Mailing Address Entity phone number Entity email Contact person Contact person address Contact person email Contact person phone number Notes: Client Updates (view only) Ability for client to leave notes to updates(triggers email to assigned town planner/da manager and also admin) Staff Admin- Access to change remove delete everything Ability to add/remove clients as above Job assigned to Town p...

I'm in need of a talented developer who can create a scraping code for 100+ websites in real-time. I've already built front end and most og back end - just need to update it to be actually scraping time tables and availabilities like these types of websites: It is important that it can be integrated into my Lovable (and Superbase) platform, so that I easily can add new websites to the Superbase which it will scrape automatically and show on my website. Key Requirements: - The scraped data should be categorized on the website under Product type, Price, Name of place, Date, Time etc. Ideal Skills and Experience: - Extensive experience in data scraping and database

...Safari, etc.) and mobile devices (iOS, Android). • It should be able to integrate seamlessly with popular CRM systems (e.g., Salesforce, HubSpot) via API or direct export. 6. Security: • The chatbot should adhere to industry-standard security practices, including data encryption (SSL/TLS), secure login protocols, and user access controls. • It should be resistant to common security threats such as SQL injection, XSS, and data breaches. 7. Localization: • The chatbot must handle locale-specific features such as currency, time zones, and date formatting for various regions (e.g., English, Chinese, and Spanish users). • It should be able to adapt to the cultural nuances of the different languages and industries. 8. Maintainability: • The system shoul...

I need a freelancer who can extract audio from my singing videos and compile them into an MP3 album. Requirements: - Extract audio from video files - Noise reduction and volume normalization on the audio - Organizing songs by theme Ideal Skills: - Proficiency in audio editing software - Experience in audio extraction from videos - Strong understanding of noise reduction and volume normalization techniques - Ability to categorize audio by themes The final MP3 album should be in standard quality."

This project involves refactoring the codebase and deployment processes for a proof-of-concept software application to implement more robust access controls and continuous delivery. Key tasks include segmenting the codebase into modular subrepositories with distinctive access permissions; establishing consistent development environments through Dockerization; automating the deployment pipeline via GitHub Actions including approval and rollback steps; configuring role-based access controls through GitHub teams; implementing post-deployment verification and alerts; hardening the deployment environment security; and setting up monitoring and logging for the application server. Upon completion, the freelancer will have refactored the codebase, refined the development workflow, automated deploy...

...devices assigned to them along with the data they have gathered on their dashboard (React JS Application). The sign-up/sign-in pages are also made in React JS. • We want the architecture to be able to accommodate future Computer Vision performed on each picture uploaded. Current state: We also have a rudimentary dashboard as a separate React Application which communicates with a sample DB on an Azure SQL server using Express. No authentication or IoT device allocation is yet implemented. Requirements: We want to have the frontend and dashboard apps along with the Express server running side-by-side, on an Azure App Service instance (Docker compose). - Azure Architecture for: o User and Device Authentication o IoT Data Ingestion and Processing o Backend Infrastructure and Sca...

...Performance Optimisation Specialist Needed Project Overview Looking for an experienced Django/DRF developer to optimise database queries and improve API performance in an existing Django REST Framework application. Required Skills Project Scope Deliverables 5+ years experience with Django and Django REST Framework Expert knowledge of database optimization techniques Proficiency in writing efficient SQL queries Experience with Django ORM optimization Strong understanding of database indexing Familiarity with Django debug toolbar and query performance analysis tools Experience with caching strategies (Redis/Memcached) Analyze current API endpoints for performance bottlenecks Optimise N+1 query problems Implement select_related() and prefetch_related() where appropriate Review an...

Prepare files for Merchandising Business cards Roll ups. Ready to print.

...interact via text, voice, or by uploading documents/images. The chatbot must perform the following key functions: 1. Case Information Collection: • Identify the legal area (e.g., tenancy law, labor law, data protection, etc.). • Ask specific, context-relevant questions based on German legal standards. • Collect and structure detailed case data from user inputs. 2. Case File Creation: • Generate a JSON-based case file that includes: • User-provided case details. • Uploaded documents/images (if any). • An AI-generated preliminary assessment of the case (success prospects, recommended actions, risks). • User’s contact information. 3. Backend Functionality: • Simple backend interface to: • Display a list of i...

hi, I need to download the size data for 1098 skus from a website

Please can you download the size data for 1098 SKUs

******Phase 1: Demo phase: Being sure working on LLM model&api, , vector db and method. Environment Setup: Install and configure Milvus as the vector database on Modal.com. Set up collections and partitions for different (2 different DB schema for demo) users and documents. Cloud GPU Server Setup: Select and download a suitable Huggingface model for token generation. Integrate the LLM Deepseek model for RAG. Document Processing. DEMO for simple prompt test on (Session or assistant or user based) $500 payment for phase 1 ******Phase 2: Production phase: Develop to work with APIs to manage document and users. API Development: Framework Selection: Use Python frameworks FastAPI Document Management APIs: Upload new documents. Delete or update existing documents. Handle changes by rep...

I'm looking for a Power BI expert to create two projects focusing on Sales and Revenue Reports from Excel or CSV data files. Key elements of the p...creating compelling data visualizations. - Strong skills in data modeling and database design. - Advanced knowledge of DAX functions for creating dynamic reports. - Proficiency in using Power Query for data transformation and cleaning. - Knowledge of Python or R scripting for advanced data manipulation. - Skills in optimizing performance for large datasets in Power BI. - Ability to write complex SQL queries for data extraction. - Experience with Power BI Embedded for integrating reports into applications. - Experience in automating report generation and updates. The reports should provide a high-level overview of sales and reven...

This project involves refactoring the codebase and deployment processes for a proof-of-concept software application to implement more robust access controls and continuous delivery. Key tasks include segmenting the codebase into modular subrepositories with distinctive access permissions; establishing consistent development environments through Dockerization; automating the deployment pipeline via GitHub Actions including approval and rollback steps; configuring role-based access controls through GitHub teams; implementing post-deployment verification and alerts; hardening the deployment environment security; and setting up monitoring and logging for the application server. Upon completion, the freelancer will have refactored the codebase, refined the development workflow, automated deploy...

I am seeking a seasoned developer to upgrade my SQL based web application. The project involves updating Angular from v12 to the latest version, .NET from V4.7.2 to the latest, and NG2 SignalR to the latest. Key Requirements: - Full stack upgrade: This is not limited to just the frontend (Angular), backend (.NET) or real-time communication (NG2 SignalR); all components need to be upgraded. - Maintaining UI layouts: The user interface layouts in the Angular application are crucial and need to be preserved during the upgrade. Ideal Candidate Skills: - Proficient in C#, .NET, Angular. - Experience with LLBLGen ORM, Formly, ag-grid, and Electron Applications. - Able to adapt and update the tech stack to the latest versions for performance improvement, new feature utilization, and comp...

I have hundreds of JPEG photos of book pages from a non-fiction books, many of which contain highlighted sections. I need an expert in OCR and AI to sift through these images and extract only the highlighted sections into a .docx file. Having the page numbers with the corresponding quotes would be ideal but not a must. Ideal Skills: - Proficient in OCR and AI technologies. - Experience with image processing and text extraction. - Ability to deliver clear, organized text in .docx format.

Insert data from wordpress and excel file to canva file in Excel (Product name, buying price in DH, buying price in USD, selling price, Total, SKU, categories, Quantity, Image in a file with naming the image base on SKU value) The pricing of products will be available in excel file that i will provide, for image and quantity and other details they will be provided in wordpress site The canva file will also be shared that need to be filled The folder also will be shared to insert images with name (SKU value)

I need an expert who can extract load charts from my PDF datasheets of approximately 127 cranes and input the data into an Excel template I have attached. Key Details: - The datasheets are in PDF format. - The layout of the load charts varies across different datasheets. - The specific information required includes both load capacity and lift height. Ideal Skills: - Proficiency in data extraction from PDFs. - Excellent Excel skills. - Attention to detail to ensure accuracy despite varying layouts. - Experience with interpreting engineering or mechanical load charts is a plus.

I'm seeking assistance with analyzing data from a case study on Zepto, specifically focusing on increased delivery times for a store. - Data Analysis: You will need to interpret complex datasets and extract meaningful insights. - Report Writing: I need a comprehensive report detailing your findings. - Presentation Creation: We'll need a visual presentation to convey the results effectively. Skills and Experience Required: - Proficiency in data analysis - Strong report writing skills - Experience creating presentations - Background in logistics or delivery services analysis preferred. - Root Cause Analysis -Solution Development

Silakan Daftar atau Login tuntuk melihat rincian.

I'm looking for a web developer to create a web application that I can run from a web browser on an Android device. The app should read QR codes and save the data in text format to a remote server. The application will be open to all ...application will be open to all users, so there's no need for user authentication or a login system. Key Requirements: - The ability to read QR codes - Text data parsing and saving - Remote server data storage - Android-compatible web application development The ideal freelancer for this project would have experience in web application development, specifically for Android devices. Familiarity with QR code technology and remote server data management is highly desirable. send me your offer, or a sample of a similar application that you p...

I need to change the few things on my STL File I just need the waves extended so that the entire crocodile fits in a square of water and waves. these waves need to be realistic because that is what i am looking for. this is really important. again, just refer to the original STL make the similar waves write " ANIMAL " in your bid if you understand

I need an expert to develop a fully functional, bug-free hosting control panel akin to cPanel/WHM. This control panel must support both Linux and Windows operating systems. Key Features: - Comprehensive domain management - File management capabilities - Email management systems - Database Management - SQL/NoSQL - Reseller Management - Docker support - All features present in WHM - Automated SSL certificate issuance, installation, and renewal for enhanced security - Automated backup and restore solutions with options for full, incremental, and differential backups - Integrated security management systems including firewall, DDoS protection, and malware scanning - Comprehensive API access for seamless integration with third-party applications - Options for custom branding an...

i need menus extracted from a webpage the most important columns (data points) will be category name product name, product price, product description.

I'm in need of a seasoned professional with a solid understanding of MVC, Angular, and SQL Server to assist in creating a basic report within our application. This application utilizes Report Builder for report generation. Key Tasks: - Log in to our server to integrate your work with the system; this is a non-negotiable requirement. - Retrieve data from the Item table for the report, specifically filteringcand sorting by some fileds. - Ensure the report is formatted for printing and exporting. If you successfully deliver this initial report, we may assign all future reporting tasks to you. Ideal Skills and Experience: - Proficiency in MVC, Angular, and SQL Server. - Prior experience with Report Builder. - Strong attention to detail and ability to follow specific instr...

I'm seeking to populate my online music teachers directory. It will consist of dance, voice, music, and instrument teachers residing in Australia. These teachers should have some Youtube channel or social media handle so we can ref...to verify the accuracy of the information. Basic verification should suffice, primarily ensuring the existence of social media links and surface-level information accuracy. Basic verification of the information using automated tools will be sufficient. The information should be maintained in a database format, allowing for efficient querying and data management. Please store the information in a SQL database format. Please set up weekly milestones to track progress. The directory should be stored in multiple normalized tables to ensure efficient d...

Hello, I am looking for an experienced SQL freelancer to help me with a complex query that involves multiple tables and conditional joins. I am working with two main databases: one that contains agricultural property sales information (`F2890_AGRICOLA`) and another that contains detailed soil composition data (`AG_CONSTRU_(SEMESTRE)`), with the tables segmented by semester. The query needs to: 1. Join the property sales table with the corresponding soil composition table based on the semester of the sale. 2. Calculate and aggregate the areas of different soil types (`COD_SUELO`) for each property. 3. Combine this information into a comprehensive output that also includes property details like `MANZANA`, `PREDIO`, and `SEMESTRE`. 4. Handle conditions where the composition might cha...

I'm looking for a skilled developer to edit our existing custom code for the CSR 8670. The goal is to enable additional functionality that will enhance our audio processing capabilities. Specific Enhancements Needed: - Allow toggle inputs to be routed through DSP processing. This should include both Line-in and Bluetooth audio inputs. DSP Processing Effects: - Implement specific DSP processing effects. These will include noise reduction, echo cancellation, and equalization. Ideal Skills and Experience: - Extensive experience with CSR 8670 and custom code editing. - Proficient understanding of DSP processing. - Prior work with implementing audio processing improvements. - Knowledge of Bluetooth enhancements and Power management optimization will be a plus....

I'm in need of a skilled web scraper who can extract data from I would also like the scraper so I can pull future data from the site. The data is highlighted in the data that I need extracted from the site (one column for each value). - Ideal Skills: - Expertise in web scraping tools/languages such as Python with Beautiful Soup or Scrapy, or similar. - Proficiency in data processing and Excel. - Attention to detail and ability to deliver accurate data. - Experience: - Prior experience in web scraping is preferred. - A portfolio demonstrating successful web scraping projects would be highly advantageous.

I need to map my Azure File Storage with users from my Active Directory. The setup should support access controls for both individual users and user groups. Key Requirements: - Implement Read and Write permissions for all mapped users. - Ensure the setup is secure and efficient. Ideal Skills and Experience: - Extensive knowledge and experience with Azure File Storage. - Proficiency in Active Directory management. - Strong understanding of access control implementation. - Prior experience with setting up Azure storage with AD is a plus. Use NTFS permissions for authentication. Focus on prioritizing specific individual users for the initial mapping. The Active Directory user base consists of 100 to 500 users. The primary purpose of the access controls for mapped users is da...

...Project Overview: We are seeking a talented freelance video ad creator to design and produce engaging, edgy video ads for Instagram and TikTok. These ads will promote our newly launched merch store and emphasize the exciting release of our new products. Responsibilities: Create dynamic, attention-grabbing video ads formatted specifically for Instagram and TikTok. Utilize provided product links to extract relevant photos and incorporate additional provided media (images, videos, and information). Develop a cohesive, edgy theme that highlights the launch of our merch store. Ensure each ad aligns with platform best practices and engages the target audience effectively. Requirements: Proven experience creating social media video ads, particularly for Instagram and TikTok. Stron...

I need a developer to make a modification to the source code of the app by adding a feature and uploading the app to the Google Play Store. Here's where I bought the source code: App created By: Android Studio With Licence Key Required modifications: - Ability to add/delete/move/hide companies under the "Offerwalls" section (no limit on the number). Add a "Surveys" section with the ability to add/delete/move/hide items. - Change the referral system to 5% or an undetermined percentage (P%). - Ability to send notifications. - Ability to create contests/competitions, for example: users who collect the most coins or refer the most people during the week earn 1,000 extra coins. - Set up the "Play Games Offerwall." -

This is a very basic project to copy information (numbers) from images on web pages into a Google Sheet document. The primary data to extract will be text. There will be just over 300 images to extract data from. Example image attached. Example finished date input attached. Each image should take approximately 5-7 mins. There are roughly 300-350 images. Please complete the project within 2 weeks. Please ensure the data follows predefined formats to maintain consistency.

I am seeking a data quality expert who has hands-on experience writing custom data quality rules specifically in Collibra from scratch based on provided specifications. The rules to be developed focus on the validity and completeness of the data. Key Requirements: - Design and implementation of data quality rules in Collibra - Focus on both validity and completeness of data - Application of ru...sources: SAP and Cloud based Databases Ideal Skills and Experience: - Extensive experience with Collibra (Specifically, how to write DQ rule logic) - Strong understanding of data quality dimensions, particularly validity and completeness - Proficiency in working with SAP and Cloud based databases - Ability to translate specifications into practical data quality rules - Expert level knowledge of ...