Sql select from csv file jobs

I'm seeking a skilled data analyst to conduct descriptive analysis on some data. Key Details: - Tools: The analysis must be conducted using SQL. - Data: While I have not specified a particular type of data, it could encompass a range of different datasets. The ideal freelancer should be comfortable working with various types of data. Ideal Skills: - Proficiency in SQL is a must. - Experience with descriptive data analysis. - Ability to work with diverse datasets. - Strong problem-solving skills.

...compound • Supplier details, including supplier name and ID linked to each structure Requirements: • Expertise in Python and database development (SQL, NoSQL, or specialized chemical databases) • Experience with chemical informatics tools (e.g., RDKit, Open Babel, ChemAxon) • Ability to handle and optimize large datasets • Familiarity with API integration for data retrieval and updates • Strong problem-solving skills and ability to create an efficient, scalable system Preferred Qualifications: • Background in cheminformatics or experience working with chemical databases • Knowledge of data visualization for chemical structures • Understanding of chemical file formats (e.g., SMILES, InChI, InChI Key, sdf, txt, xlsx, MOL) If you h...

...297600 Per day If center runs 26 days in a month then - 29760*26 = 773760/- Approx Payment: After Invoice within 10 working Days Payment Cycle: 20 Day PAY CHANNEL: SWIFT Transfer Advance Billing: Available from Client after days of going Live Sign up with: - End client based in the USA and sign up will be at vendor’s office in India Training: Training will be onsite by Client Representative, for 16 international working days. Center needs to bear the up and down cost of Travelling for trainer and arrange for hotel accommodation. After training certification will be done from the Client end. Reference center is in Mumbai. Center can visit there to see the operations. They are running for 4 months. Payment proof can be shown upon request to interest centers on...

I have over 400 customers who pick up products from 18 pick up locations each week. These customers sign in at the location via a QR code that is linked to a JotForm. I need a Google Sheet that pulls data from my JotForm submissions to show who has signed in and who has not. The sheet should automatically update weekly to reflect current data. It should also be capable of distinguishing between customer orders via the Order ID from my website's API. Key Requirements: - The sheet should incorporate specific fields from JotForm submissions: Customer name and contact info, Submission timestamp. - Data should be organized by Pick Up Location. - Knowledge of API and Google Sheets is essential. - The ability to distinguish different customer orders using the Ord...

...297600 Per day If center runs 26 days in a month then - 29760*26 = 773760/- Approx Payment: After Invoice within 10 working Days Payment Cycle: 20 Day PAY CHANNEL: SWIFT Transfer Advance Billing: Available from Client after days of going Live Sign up with: - End client based in the USA and sign up will be at vendor’s office in India Training: Training will be onsite by Client Representative, for 16 international working days. Center needs to bear the up and down cost of Travelling for trainer and arrange for hotel accommodation. After training certification will be done from the Client end. Reference center is in Mumbai. Center can visit there to see the operations. They are running for 4 months. Payment proof can be shown upon request to interest centers on...

I require a proficient web scraper to gather contact details from websites. The final data needs to be formatted into an Excel spreadsheet. Ideal Skills and Experience: - Proficient in web scraping tools and techniques - Experience in data collection from websites - Ability to organize and format data into Excel - Attention to detail to ensure data accuracy

... Monitoring of sales and accumulated commissions. Request for withdrawal of commissions. Updating bank details or PayPal/Mercado Pago to receive. ✅ Integration with Payment Gateways PayPal: Checkout and automatic payment return. Mercado Pago: Checkout and automatic payment return. Automatic registration of sales and calculation of commission for the corresponding affiliate. ✅ Database SQL Server or MySQL to store users, affiliates, transactions and payments. ✅ Other Requirements: Clean and well-documented code. Responsive and user-friendly interface for affiliates and administrator. Security and protection against fraud in the payment system. Differentials: Experience with integration of PayPal and Mercado Pago APIs. Experience with developing affiliate systems. ...

I'm looking for a skilled web developer to create a resume builder website for me. The site should allow users to select from various templates and input their information through a form-based system. Once completed, users should be able to download their resumes as PDFs. Key Features: - Template Selection: A variety of professional resume templates. - Form-Based Inputs: An easy-to-use interface for users to input their personal and professional information. - Download as PDF: A seamless process for users to download their resumes in a universally accepted format. - AI Resume Builder: An AI system that can automatically generate resumes based on user inputs. Ideal Skills: - Proficiency in web development technologies (HTML, CSS, JavaScript, etc.) - Experience with impl...

I'm looking for a professional with experience in data collection and SQL database creation to compile a comprehensive list of all family doctors in the Greater Toronto Area using publicly available data. The database should include their names, addresses, fax numbers, and contact numbers. Key Details: - The data should be sourced entirely from publicly available resources - The project also involves faxing marketing materials to these doctors at the end. - The contractor should ensure the accuracy and reliability of all collected data. - Include a mechanism for updating the database in the future as new data becomes available. - Implement a backup and recovery strategy to protect the database against data loss. - All data should be handled securely to protect against u...

I need someone to help me with data entry on my WordPress site. The task involves transferring data from another site into my WordPress site. The job involves 600 products, specifically car wrap films. Data to be transferred includes: - Product descriptions - Price variations - Product Images I have some images, but will need assistance in sourcing additional ones. The data from the source site is in a CSV/Excel format. Ideal skills and experience for this job: - Proficiency in WordPress - Excellent data entry skills - Experience with product data entry - Ability to source product images - Familiarity with handling CSV/Excel files. Please ensure you have the necessary skills before bidding. Thank you.

I need assistance with entering mixed data (both text and numerical) from scanned documents into an Excel spreadsheet. The data does not require any specific formatting and can be entered in a standard table format. Ideal skills and experience for the job: - Proficient in Excel - Detail-oriented - Experience with data entry - Ability to transcribe information accurately from scanned documents

I'm looking for a detail-oriented freelancer to assist with a simple data entry project. The task involves copying text data from a digital Excel file into online database records. Ideal Skills: - Proficiency in Excel - Attention to detail - Good understanding of text data - Ability to maintain data confidentiality Experience: - Prior data entry experience preferred - Familiarity with handling digital files Other: - Can perform duties during normal Mountain Standard Time working hours - English-speaking Please bid if you can meet these requirements. Thank you.

1. I will be buidling a new LWC component which whill execute CRMA Query to reterive date (LWC and CRMA Integration) 2. Giving ability for inline edit for opportunity Name, Amount as part of PoC if more fields are required we will exend our PoC 3. LWC will be compatible with Filters which are displayed on CRMA Dashboard 4. Adding LWC to CRMA Dashboard

...Key Responsibilities: - Apply various classification algorithms to numerical data. - Help in interpreting the results and refining the approach. - Evaluate the models using appropriate metrics such as accuracy, precision, recall, and F1-score. - Preprocess the data to prepare it for classification tasks. - Create visualizations to better understand data distribution and classification results. - Select and engineer features that improve model performance. - Perform hyperparameter tuning to optimize classification algorithms. - Implement cross-validation techniques to ensure the robustness of the model. Ideal Skills and Experience: - Proficiency in machine learning, specifically in classification tasks. - Experience working with numerical data. - Familiarity with a range of class...

I'm looking for a web scraping expert who can extract Over/Under lines (all lines , not only the main one) for all MBL (Baseball) and NHL (Hockey) games from the past 5 seasons. The data should be delivered in an Excel (XLSX) format. Key Requirements: - Expertise in web scraping - Proficient in data handling and Excel - Familiarity with MBL and NHL data - Ability to extract specific betting lines The ideal freelancer for this project would be detail-oriented, with a proven track record in web data extraction, particularly in the sports and betting domain. The ultimate goal is to get comprehensive, clean data for analysis.

We are seeking an experienced web developer to assist us in transitioning our existing website from ModX to WordPress. The ideal candidate will have a strong background in website migrations and a deep understanding of both CMS platforms. You will be responsible for ensuring all content, media, and functionalities are seamlessly transferred without any loss. Attention to detail and a commitment to maintaining the website's integrity during the migration process are essential. If you're passionate about creating efficient and user-friendly websites, we'd love to hear from you!

I need a skilled 3D modeler to create and render a 3D model of house plans I have in PDF format. The plans were created by an architect and are intended for community approval. The model should encompass both the interior and exterior, with a focus on the basic layout for the interior and the base level of the structure for the exterior. Key Requirements: - 3D modeling and rendering of house plans - Basic layout of interior (walls, doors, windows) - Exterior showing just the base level of structure - Display of color schemes in architectural language The aim is to showcase the finishes and design intent clearly. Therefore, proficiency in 3D modeling software and a keen eye for architectural details is essential. Experience with similar projects in the past will be a plus.

I'm seeking a professional to build a basic corporate-style, 5-6 page WordPress website for my company. This site will primarily showcase our services. Key Responsibilities: - Install and configure WordPress on my server - Select and install a suitable corporate and professional theme - Create a basic page structure including Home, About, Services, Contact, and Blog - Upload and format provided content - Set up essential plugins such as SEO, Contact Forms, and Security - Ensure the website is mobile responsive and conduct necessary testing Ideal Candidate: -The ideal freelancer has extensive experience with WordPress and is capable of creating a corporate and professional website. They should have skills in SEO and website security, and a good understanding of mobile respons...

Freelancer Task: Azure MS SQL Database & Data Pipeline Setup Project Scope The freelancer will deploy a cloud-based Microsoft Azure SQL Database, set up an automated data pipeline for Excel uploads, and provide a management interface for querying the data. Requirements 1. Azure SQL Database Setup Deploy an Azure SQL Database (PaaS) instance. Create three tables using data from provided Excel sheets. Define appropriate data types, constraints, and indexing for optimised performance. Provide SQL scripts for table creation and initial data import. 2. Azure Virtual Machine (VM) for Management Provision an Azure Virtual Machine (Windows-based) to serve as a management server. Install and configure Microsoft SQL Server Management Studio (SSM...

I require a Python web scraper utilizing Selenium to extract LLC and business entity details from the Massachusetts Secretary of State's website. The script needs to: - Source LLC names from a provided CSV file and execute searches on the website. - Extract and save data including Business Name, Entity Type, Status, Registration Number, Registered Agent, Address, and Officers. - Identify and handle variations in LLC names, with a mechanism for retrying searches as necessary. - Output results to a file named , with unmatched entries directed to Not_Found.csv. Requirements for the script: - Must be compatible with Python and Selenium (Chrome WebDriver). - Should robustly manage timeouts, CAPTCHAs, and variations in search queries. - Designed as an e...

I have a Word document containing names, emails, numbers, specialties, subspecialties, states, and cities. I need this data entered into an Excel spreadsheet with separate sheets for each category. Key requirements: - Proficient in Excel and data entry - Attention to detail to ensure data is accurately transferred - Ability to organize data into separate sheets by category

...html#vehicle-enquiry-service-ves-api-guide) and displays the car make, model and colour. The first phase of this project is to: - copy so that it has the similar content and the same user journey. - Write out the details to a CSV file on the backend. What is NOT required: - Integration with STRIPE - this will be done later. So this stage can simply be a button which doesn't do anything. IMPORTANT - Please note how renders differently on a mobile phone from a desktop. When my site is accessed from a mobile device it would also display similar to Once the first phase is completed and the source code delivered and confirmed that it works - I may then wish to work with the same developer on improving the site.

i have 3 VPS servers. You need to create master-master replication of database server and files (realtime).  You also need to setup plesk panel trial with mariadb 10.x

...I have been considering creating a short video for each individual class, so this added content would need to fit into the current design. • Schedule page: This page lists classes using The Event Calendar. Currently, the events listed are very plain. I could use some graphic elements or images to make this a bit more interesting. - I want to make it easier for a potential customer to select and purchase a scheduled class. • About page: This page might be okay as it is. However, I am open to design suggestions or a mock-up. • Login page: This page is probably okay as well. However, I am open to design suggestions or a mock-up. 6. My goal is to have this site fully functional by the end of January, or early February. I believe the changes required ...

I'm in need of a Python expert to assist me with a code. The primary objective is to help me write text data to a file in JSON format. Key Tasks: - Help with writing Python code that writes to a file in JSON format. - Optimize the code for efficiency and clarity. Ideal Skills: - Proficient in Python programming. - Experienced in working with JSON. - Able to write clear and efficient code.

I'm looking for a freelancer who can assist with manual data entry from video screen recordings. The data is mixed, comprising both text and numeric information. Ideal Skills: - Proficiency in data entry - Attention to detail - Ability to transcribe from video accurately - Experience with handling mixed data (text and numbers) - Familiarity with basic data handling software Data Handling: - The data you will be entering is not exclusively text or numbers; it is a combination of both. Therefore, comfort and competence in working with mixed data is essential. - The data is currently stored in video screen recordings, which will require your ability to transcribe accurately and efficiently from visual and auditory sources. Please apply only if you are confident ...

Please do translations for the new product, in five languages (FR, IT, ES, UK, NL) using keywords where relevant. Link to our product -

I need a custom ordering form for a client's bespoke furniture requirements. This form should allow the client to browse through various furniture pieces, select the desired items and quantities, and subsequently generate a summary with the total cost. Key Features: - Selection of Furniture Pieces: The form should allow customers to choose from a range of furniture pieces. - Detailed Capture: The form needs to capture specific SKU information for each available piece. - Automatic PO Generation: On submission, the form should create a Purchase Order (PO) with the selected items and their corresponding SKUs for production. Ideal Skills: - Experience with form development. - Proficiency in database management. - Familiarity with e-commerce and ordering systems. This pro...

I'm looking for an experienced Shopify developer who can create a highly customized booking tool for my event halls. This tool should accommodate several specific requirements: - Customers should have the ability to select and book time slots. - If a customer indicates more people than the maximum capacity per room allows, they should be informed about the possibility of booking an additional room. The system should also evenly distribute the people between both rooms. - Customers must input their personal contact details (full name, phone number, and email address) during the booking process. - A reminder email should be sent to customers one day before their booking date. - Employees should be able to sign up for shifts in a calendar, with cancellation only possible after a...

I'm looking for a freelancer who can independently manage and accurately transfer information from various sources into an Excel spreadsheet. The specific sources will include paper documents, spreadsheets, and online forms. The ideal candidate should have experience with data entry, attention to detail, and proficiency in Excel. Key Skills Required: - Data entry - Excel proficiency - Attention to detail

I'm in need of a web scraping professional adept in Python and familiar with tools like Scrapy, BeautifulSoup, Requests, Selenium, or Playwright. The job involves extracting real estate agent data from Realtor.com. Key responsibilities will include: - Scraping agent names and contact information from the site. - Successfully navigating and handling dynamic content. - Implementing measures to circumvent potential anti-scraping protocols. The extracted data should be delivered in a CSV file. This project is a one-off task, and I don't require ongoing updates or data scraping. Ideal skills and experience for the job include: - Extensive knowledge and practical experience in web scraping. - Proficiency in Python. - Familiarity with real estate websites...

I am in need of a professional to assist with hosting our SQL Express database on an Apache web server and ensuring two-way synchronization of this data. Key Requirements: - Expertise in SQL Express database management - Experience with web server - Proficient in implementing two-way data synchronization - Familiarity with syncing data across Web and Desktop applications Ideal Skills: - Strong understanding of SQL and database hosting - Proven experience with web hosting / web server and real time data synchronization from Windows to web server - Excellent troubleshooting skills - Ability to work efficiently and meet deadlines

I'm seeking a talented video editor with experience in crafting engaging social media content, specifically tailored for Instagram. Video Requirements: - Editing of raw footage into a captivating 1-minute video - Experience in creating content for Instagram is a must - Include accurate and engaging subtitles to enhance video accessibility. - Select and integrate suitable background music to complement the video. - Add text overlays that highlight key points or messages in the video. - Render the final video in high resolution to ensure quality on various devices. - Apply color grading to enhance the visual appeal and consistency of the video. - Ensure the video is cropped to the correct Instagram aspect ratio (e.g., 1:1, 4:5). - Use creative transitions and visual effects to ...

I'm seeking a developer/consultant for our Retail Management software. The ideal candidate should have 2-5 years of experience working with Delphi and SQL Server, preferably within the retail domain. Key Areas of Focus: - Sale Management - Inventory Management - Barcoding - GST - Sales Reporting - Customer Relationship Management (CRM) Main Tasks: - Bug fixing and maintenance, New Development, primarily focusing on the Point of Sale (POS) System. Skills & Experience Required: - Proficiency in Delphi and SQL Server - Prior experience in retail software development - Strong problem-solving skills for bug fixing and maintenance tasks. This project is expected to be completed within 2 years. The consultant will primarily focus on development tasks with minimal inv...

I have an Excel with 5 soccer leagues and I would like the games and the position in the classification of each team to be updated every day. It would be to associate Excel with the Internet and refresh the sheet with a button. My budget is 15 euros.

I need assistance with data entry, specifically handling numerical data sourced from online databases. The specific format for the entered data will be confirmed later but it is likely to be an Excel spreadsheet or a CSV file. Ideal Skills: - Proficiency in data entry - Experience with numerical data - Familiarity with online databases - Attention to detail - Ability to work efficiently and accurately

I'm looking for a freelancer proficient in data entry with a focus on numerical data. The data will be sourced from various databases, so experience working with databases is crucial. Key Requirements: - Strong attention to detail to ensure accuracy in data entry - Proficiency in handling numerical data - Prior experience with data entry from databases - Excellent time management skills to meet deadlines The specifics of the databases won't be disclosed upfront, so flexibility and adaptability will also be key to successfully completing this project.

Fulltime Job - Preferrably from India, Israel, Ukraine, Hungary, Sweden, and the Philippines. Company Name iAcuity Fintech Position Title Software Engineer – FullStack Experience 5+ years of experience in software development. Education B.E/ MCA/ Job Location Work from home (Permanently) Job Description Key Responsibilities: • Design, develop, and maintain robust and scalable web applications using : * Mandatory * - Java 17+, Spring Boot, and Angular/React. • Develop RESTful APIs and microservices using Spring Boot framework. • Implement complex search functionalities using Elasticsearch 8. • Collaborate with cross-functional teams to understand requirements and translate them into technical solutions. • Write clean, well-structured, ...

I'm in need of a distinctive name for my fashion brand, which embodies a casual and streetwear style, targeting primarily adults. The name should reflect our core values of sustainability, trendiness, and affordability. Key...reflect our core values of sustainability, trendiness, and affordability. Key Requirements: - Experience in branding, particularly in the fashion industry. - Understanding of casual and streetwear style. - Ability to create catchy, memorable and unique brand names. - Should reflect the brand's values. - Proven creativity in generating unique and appealing names. - Understanding of SEO principles to select names that are easy to find online. - Deep insight into the preferences and behaviors of the target audience. Please provide samples of previous ...

I'm seeking a Yii PHP expert to implement a Figma design onto my website. Key Requirements: - Change the website's design according to a provided Figma file - No new functionality needs to be added, just the design changes Ideal Skills: - Proficiency in Yii PHP - Experience with Figma - Strong understanding of web design principles Please note: The Figma file will be shared upon agreement, and its organization may vary. Previous experience with Figma is highly advantageous.

I'm looking for a professional image editor to enhance my product images by placing them on scenic backgrounds. Key Requirements: - Background editing: Your primary responsibility will be to seamlessly remove the original backgrounds and replace them with custom scenic backgrounds. - Expertise in creating a visually appealing and fitting backdrop f...backgrounds. Key Requirements: - Background editing: Your primary responsibility will be to seamlessly remove the original backgrounds and replace them with custom scenic backgrounds. - Expertise in creating a visually appealing and fitting backdrop for the products. Ideal Candidates: - Proficient in using image editing software - Prior experience in product image editing - Creative mindset to select and implement suitable sce...

As a loving tribute from her 4 children and 13 grandchildren, I need a professional video editor to craft a touching birthday video for my mum. This project involves compiling special messages from all of us, interspersed with a mix of old and new photos of grandma and the grandkids, all set to a slow and sentimental soundtrack. Key components of the project: -Collect and incorporate short birthday messages from 4 children and 13 grandkids. -Edit a mix of old and new photos of grandma and the grandkids into the video. -Select and sync the video to a slow and sentimental piece of music. -Deliver the final product in MP4 format. - Add smooth transitions between video clips and photos. - Create an engaging intro title sequence for the birthday video. Ideal skil...

Up my PHP app from php 5.6 to php 7.4

I need an expert in MySQL for data analysis. The primary focus is descriptive analysis using data from CSV/Excel files. Key Responsibilities: - Analyze data from provided CSV/Excel files using MySQL. - Conduct descriptive and predictive data analysis to extract insights. Ideal Skills: - Proficiency in SQL. - Strong background in data analysis, particularly descriptive analysis. - Experience working with data from CSV/Excel files.

I'm looking for a skilled graphic designer who can transform my sketch into a professional logo. - The logo should predominantly use warmish colors. - Experience with creating modern, vintage, or minimalist styles is a plus, though I have not yet settled on a specific style. - Ultimately, the designer must be able to deliver the final logo in multiple file formats including PNG, SVG and EPS. Key skills: - Graphic Design - Logo Design - Proficiency in Adobe Illustrator or equivalent software.

I'm looking for someone to download public documents from the corporate registry of Bangladesh for a few companies. The documents I need are: - Annual Reports - Registration Certificates - Financial Statements - Memorandum of Association - Articles of Association - List of Shareholders - Minutes of Board Meetings - Details of Capital Structure - Details of Directors - Business Licenses and Permits - Annual Tax Filings - Auditors' Report This task involves gathering information for 1-5 companies. The documents should be downloaded in PDF format. Ideal skills and experience for the job: - Familiarity with corporate registries - Proficient in document handling - Able to deliver in specified format - Keen attention to detail The documents should be delivered within 1-3 da...

I need a professional with access to either Zoominfo or Cognism to assist in obtaining contact information for a list of names I have. Requirements: - Retrieve email addresses and phone numbers from Zoominfo or Cognism for over 500 contacts. - Identify and locate the contact information across any industry. Ideal Skills: - Expertise using Zoominfo or Cognism. - Excellent data sourcing and retrieval skills. - Strong attention to detail to ensure accuracy of contact information. Please reach out if you can assist.

I'm looking for a talented full stack web developer with a strong focus on UI/UX. The project will involve both front-end and back-end development, so comprehensive skills in these areas are essential. - UI/UX: A keen eye for...blog, etc.) and the most important aspect of the project (user interface design, backend functionality, full stack integration) are yet to be determined. Skills and experience required: - Proficiency in HTML, CSS, JavaScript, and relevant frameworks (React, Angular, Vue for front-end; Node.js, Express for back-end) - Strong understanding of UI/UX principles - Experience with database management (SQL, MongoDB, etc.) - Familiarity with server management - Excellent problem-solving skills - Strong communication skills - Ability to work independently and...

python script or web scrping from a single website should be performed today. The data should include text content. The extracted data should be provided in CSV format. Please extract all available data from the website.

I'm looking for a talented PHP developer to create a dedicated Control Panel for SEO activities on our website, www.teachersjobs.in. The site is built on the PHP and Smarty framework with SQL as the database. The Control Panel should support: - Meta tag management - Keyword analysis tool - Backlink tracking It should also accommodate multiple user roles, not just an admin. While it won't require real-time monitoring, it should still have the capability for regular analytics tracking. Ideal skills and experience for the job include: - Proficiency in PHP and Smarty framework - Experience with SQL databases - Prior work creating SEO Control Panels - Knowledge of implementing user access levels - Ability to integrate tracking and analytics features.