Sql in r tutorial jobs

I am currently using R, specifically the ppcor package, to conduct partial correlations on a sizable dataset. Unfortunately, the process is slow and fails to address all columns efficiently. I'm seeking assistance to: - Improve the computation speed - Enhance the handling of columns within my dataset The ideal freelancer for this task should be proficient in R programming, with specific experience in working with the ppcor package or similar tools for statistical analysis. A background in optimizing code for large datasets would be highly beneficial.

Hi Raquel R., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

I need to run TTS wine voices from Linux in docker. I found two tutorials that explain how. Or I need a developer to go through each tutorial and see if you can run the wine gui environment from a docker. Then package that solution as a Docker image I can run locally on lubuntu 22.04. I would do it myself, but I don’t have much experience with docker Requirements: 1 Install balabolka in wine - 2 Install cli balalbolka “bconsole”

Please Sign Up or Login to see details.

...specialist to write code in Python (preferably) that scrapes a specific table from a website for me (Website: ). The table contains WNBA player statistics, The goal is to extract all columns of this table, which is approximately 7 columns and write it to a CSV file (in the same column format). I'm a beginner level coder, and noticed that the table was created with that looks like a Shiny App in R. (I'm not even sure if extracting the table is possible). If it was only possible to use R, then I could potentially work with that. Website: I would like the data to go from the year 2020 to current. Regular Season data. Key Requirements: - Scraping Tables on websites If you're confident in your web scraping abilities

Hi Souvik R., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

I am seeking a talented video editor to edit programming tutorials on Javascript targeting beginner-intermediate levels. The project involves: - Ed...talented video editor to edit programming tutorials on Javascript targeting beginner-intermediate levels. The project involves: - Editing raw footage to produce concise and engaging 10-25 minute tutorial videos - Revamping the content where required to make it easily understandable for beginners - Implementing graphical elements to clarify and highlight key points Ideal candidates should possess: - Experience in video editing, preferably with similar projects - Familiarity with Javascript to ensure accurate representation and explanation of concepts - The ability to creatively present complex information in a simplif...

...information management processes and methodologies. Skills in database design, data security, and data lifecycle management (i.e., gathering, cleansing, publishing, archiving, back-up and recovery, and purging) for large enterprise systems. Familiarity with master data, metadata, reference data, data warehousing, database structure, business intelligence principles and processes, and technical architecture. Knowledge of database management systems, metadata management tools, cloud storage, and associated security considerations. . Combinations of experience and education will be considered on a case-by-case basis. Experience in data warehousing and governance. Practical experience in enabling data usability, availability, and efficiency. Experience in data ma...

I'm looking for an expert in Microsoft Power Apps to develop a canvas screen for me. The screen will enable the gathering and insertion of information into a database. Requirements: - Incorporate text inputs, dropdown menus, and date fields for gathering information. - The preferred database language is Microsoft SQL Server but SharePoint can be used as an alternative. Additional Information: - You don't need to worry about any additional features or functionalities. The main goal is to develop a basic, yet effective form for data collection. Ideal candidates should have experience in: - Microsoft Power Apps development. - Integrating Power Apps with databases, specifically Microsoft SQL Server. You should be comfortable working independently a...

...Design and Coding, and a strong handle on Logic Synthesis and Optimization, as well as Physical Design and Floorplanning. Key Requirements: - At least 5 years of experience as a VLSI Backend Engineer - Strong knowledge in scripting using TCL and Python - Hands-on experience with full RTL to GDS-II flow for complex designs - In-depth knowledge of Synthesis, P&R, and STA flows - B.Sc. / M.Sc. in Electrical Engineering from a leading institute Your role will involve collaborating extensively with our team, so strong collaboration skills are a must. Your role will be crucial in our overall product development and we need someone who can contribute effectively and communicate clearly....

Hi Ahmad R., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

I am in need of a skilled animator to create a 3D promotional animation for my locker product. The target audience for this video is adults, so the animation should be informative and visually appealing to a mature audience. Key requirements and responsibilities include: - Creating a 3D animation styled video - Crafting the video with a primary focus on promoting the benefits and features of the locker product - Ensuring the video is engaging and attractive to adults Ideal skills and experience for this project: - Proficiency in 3D animation - Prior experience in creating promotional content - Understanding of adult audience preferences and visual aesthetics - Ability to deliver high-quality work within a specified timeframe If you have a portfolio that showcases yo...

...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 in designing sophisticated, interactive visual reports - Strong understanding of d...

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: The d...

...Transfer 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,

I'm in need of an expert in creating engaging motion graphics videos. The job focuses on two main areas: producing clear, concise, and easy-to-follow tutorials and crafting appealing videos for the promotion of my brand. Key Responsibilities: - Develop compelling motion graphics for tutorials that are simple and engaging. - Design and produce high-quality promotional videos, oriented towards educating the audience about my services and benefits. Ideal Skills and Expertise: - Proficiency in motion graphics and animation. - Strong understanding of video creation and promotion. - Experience in making educational promotional content. - Ability to convey complex messages in a clear and concise manner.

...WEEKENDS AS WE HAVE SEVERAL EMERGENCIES TO FINISH URGENTLY. We will start with 5-10 small task in and then go to some 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 plu...

I'm looking for an expert in Fast Fourier Transformation and/or Wavelet Analysis to transform temperature readings into a frequency/bpm output. This project is intended for a research project I am undertaking. I am looking to see if FFT/Wavelets are able to produce acurate bpm readings so there is not definitive method to follow which is why I require your help/ Key requirements include: - Utilizing Fast Fourier Transformation and/or Wavelet Analysis to transform the raw temperature data. (Data is in the form of multiple .csv files with temperature readings and time stamps). Ideal skills for this project include: - Proficiency in Fast Fourier Transformation and Wavelet Analysis. - Strong command of R programming language for generating the output in...

Background: King Faisal Hospital Rwanda (KFH-R) is a leading healthcare institution in Rwanda, renowned for its commitment to providing quality healthcare services to the community. In line with its vision for growth and expansion, KFH-R is transforming into an academic health sciences institution with a global impact, Africa Health Sciences University (AHSU). AHSU is an accredited institution that will train the next generation of health professionals across medicine, pharmacy, nursing and midwifery, laboratory technology, radiography, and other allied health professionals. Objectives The primary objective of this project is to develop a comprehensive branding strategy and implementation plan for Africa Health Sciences University (AHSU). The key objectives i...

Hi Moshiur R., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

Hello, We are F12Design, a platform where customers and designers come together and collaborate on graphic design projects. We would like to build an interactive dashboard to make the workflow simple and effective. Here are a few things on our 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

I'm seeking a dedicated professional who is proficient in video editing to create a tutorial video. The main purpose of the video will be for tutorial purposes and it should follow a live-action style with an in-person demonstration. Although proficiency in any video editing software is acceptable, I welcome any freelancers who are adept at using software like Adobe Premiere Pro, Final Cut Pro, or Sony Vegas Pro. The ideal candidate for this job would possess: - Proven experience in video editing - Ability to shoot live-action sequences for tutorial purposes - The knack for adding innovative and creative elements to make the tutorial engaging. Only those with a portfolio showcasing similar past work will be considered. The fi...

...talented video creator who specializes in crafting tutorial videos. The sole focus of the videos will be on legal topics, breaking down complex legal concepts into understandable lessons for viewers. Each video should ideally span a length of 30 minutes, with attention paid to maintaining viewer engagement throughout. Key Responsibilities: - Create high-quality tutorial videos on legal topics - Ensure the video length is around 30 minutes - Break down complex legal subject matter into digestible content Ideal Skills and Experience: - Proven experience in video creation, particularly tutorials - Knowledge or interest in legal subject matter - Ability to engage viewers for extended periods Please provide examples of previous...

...that makes manual data entry easy and intuitive. Skills and Experience: - Proficiency in spreadsheet software such as Excel or Google Sheets is essential. - Experience in financial tracking and net worth management is highly beneficial. - Understanding of stock market, investment tracking, and basic accounting principles is a plus. Delivery: - I expect the freelancer to deliver a comprehensive, error-free spreadsheet that meets the specified requirements. - The spreadsheet should be easily updatable and not reliant on external sources for data input. - A brief tutorial or guide on how to use the spreadsheet would be appreciated. Feel free to share any relevant work samples or experience you have in this area. I'm open to suggestions on how to i...

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 offe...

I'm looking for a detailed guide on how to get tweets using the RTweet library in R. Key points include: - Explaining the setup process of the Twitter Developer Account since I'm facing issues with access - A detailed, step-by-step guide on how to leverage the RTweet library for tweet lookup and analysis - Troubleshooting guidance for known issues Ideal skills: - Proficient in R programming language - Strong understanding of the RTweet library - Experience with Twitter Developer account setup - Ability to explain complex concepts in a simple manner - Troubleshooting experience with the Twitter API

...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 columns. The column names are,...

...management, budget tracking, and document sharing. The primary function of this software will be to drive project efficiency by keeping all project details organized, deliver real-time budget oversight, and facilitate instant file exchanges. This tool is intended for use by my project managers and office administrators. Consequently, the ideal freelancer for this task should possess a strong proficiency in cloud-based software development, particularly those intended for construction project management. Your experience should also extend to designing user-friendly interfaces that cater to the needs of project management and administrative professionals. Web Application A cloud-based platform designed to streamline project management, financial tracking, and employee/subcontracto...

I need an expert in data entry, cleaning, and data visualization in RStudio. The primary goal of this project is to identify trends in a small dataset (less than 1,000 rows). Ideal Skills and Experience: - Expertise in data entry, cleaning, and visualization in RStudio - Strong understanding of R Programming - Proven experience working with small datasets with missing data - Ability to identify trends through data analysis Please only apply if you have demonstrable experience with RStudio and data analysis. The ideal candidate should be able to extract meaningful insights from data and present them in a clear and concise manner.

...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 is a must. Ideal Skills and Ex...

Data Specialist: The Data Specialist is responsible for providing 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 peo...

...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 noti...

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 proje...

...am seeking a seasoned web developer to create a clean, clutter-free, and highly informative website in the agricultural bio-chemical industry. The website will consist of 5 pages and must include information on crop protection, soil health, research and development, news timeline and crop yield. Key Features: - Infographics: aesthetically pleasing and informative - Video on landing page: showcasing the beginning of an exciting journey. The option to view the video must be available. - Press release Timeline: this will serve as the news timeline. Key Sections: - About Us: this section should introduce our company and its mission. - Services: a comprehensive list of services that we offer. - R&D / USF Connect: this is our research and development section, providing ins...

...Analytics specialist who could coach me in the areas of Data Analysis and Data Visualization. The role may also involve programming. Key points: - Coaching: I need 1/1 coaching via Teams on Data Analysis & Data Visualization within Azure Analytics - Programming: If the opportunity arises, the candidate could get involved in programming using SQL - Proficiency: I consider myself at an Intermediate level with Azure Analytics Ideal Skills and Experience: - Proficient in Azure Analytics: You should have a strong understanding of Azure Analytics, specifically in Data Analysis and Data Visualization - SQL Programming: Experience with SQL is a must as you may be involved in programming for this project - Teaching or Coaching Experie...

...able to view the tutorial anymore. Video must not be downloadable If you will require more than $200 please don’t bid. Lowest bid gets the work Key Features: - Video Hosting: Implement a secure and reliable way to host my video content on the website. - Limited-Time Access: Set up a system that allows users to purchase access to the videos for a specific period, after which their access will be revoked. - User Registration: Implement a simple user registration system that enables users to create accounts on the platform. - Payment Integration: Integrate Credit/Debit Cards and PayPal as payment methods to facilitate the purchase of video tutorials. Ideal Skills and Experience: - Proficiency in web development, particularly in creating video hosting platform...

Hi Yuriy R., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

...information management processes and methodologies. Skills in database design, data security, and data lifecycle management (i.e., gathering, cleansing, publishing, archiving, back-up and recovery, and purging) for large enterprise systems. Familiarity with master data, metadata, reference data, data warehousing, database structure, business intelligence principles and processes, and technical architecture. Knowledge of database management systems, metadata management tools, cloud storage, and associated security considerations. . Combinations of experience and education will be considered on a case-by-case basis. Experience in data warehousing and governance. Practical experience in enabling data usability, availability, and efficiency. Experience in data ma...

I'm in need of a skilled developer who is experienced with inventory management systems, report production, analytics, user access control, and Windows-based applications. This job involves maintenance of a warranty return tracking software, with specific attention to: - Inventory management: Ensuring that the software effectively tracks the inventory of returned products - Reporting & Analytics: Enhancing the software's capability to generate insightful reports about warranty returns. - User access control: Improving the control measures for different user permissions within the software. - Ticket creation, Data Import and Export: Aptitude in handling these features are considered a plus. The overriding purpose of this software is to track and manage warranty...

I need an adept SQL developer proficient in crafting SQL queries for various tables within our database. The task entails generating four queries, each encompassing approximately 20 conditions that must be met. Utilizing ChatGPT, could you assist in devising these queries?

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: The d...

...currently in the development stage of a pharmaceutical product and I'm seeking for an experienced pharmacologist with a deep understanding of active pharmaceutical ingredients (API) and pharmaceutical products, and a successful track record in the industry. Key Responsibilities: - Research and Development: I need the freelancer to contribute substantially to the ongoing research and development of the product. - Regulatory Compliance: You should have a deep understanding of pharmaceutical regulations and be able to ensure that our product complies with all relevant standards. - Product Formulation: The ideal candidate should have extensive experience in product formulation, and be able to help bring our project to fruition. - Pharmacokinetics & Pharmacod...

Note: Budget Fix 2000INR and time line 5 Day's I have a project currently in Codeigniter 3, and I'd like it converted to Laravel 10. This process will require thorough understanding of both frameworks, and it's crucial that all existing features and functionalities are precisely replicated in the new version. While I don't have specific features to prioritize, I will identify specific elements as the project progresses. Skills and experience required: - Profound knowledge in Codeigniter 3 and Laravel 10 - Expertise in PHP development and SQL databases - Proven experience in similar conversion projects Note: The finalized budget for this project is 2000INR. Please only bid if you can work within this budget. The timeline for ...

...click on an FTP URL link on a website (various browsers) or in mail clients (e.g. Thunderbird). After setting it up once, it should no longer be necessary to enter the FTP access data again. The FTP server expects Explicit SSL/TLS (port 21). The link/URL typically has the following structure: ftp://ftp_username[at] Either the user should be asked where he wants to save the download file, or it is permanently saved in the settings. Ideally, well-known applications are used for file transfer, such as WinSCP, FileZilla or MS File Downloader. Your own suggestions are welcome. 1. Milestone: Setup as described above on a user PC via a TeamViewer session 2. Milestone: Creation of an easy-to-follow tutorial so that I or a user can carry out the installation on other

I have wine labels for 3 different wines, each with a front and back label. I need these labels converted to Avery labels in the 95.5 x 65mm R size (8 per sheet). Key requirements: - Conversion of 6 label designs to Avery labels - Expertise in working with InDesign and PDF files - Attention to detail to ensure accurate label placement - Familiarity with Avery label templates This project is for personal use, and I already have all the necessary files. I'm looking for a skilled professional who can complete the task efficiently and accurately. If you're confident in your capabilities, please provide information on your experience with similar projects and an estimated cost for this job.

I'm in need of a Machine Learning Engineer who can help fine-tune Llama3 with a custom dataset. Key Requirements: - Experience with Machine Learning - Proficiency in Llama3 - Ability to work with custom datasets - Strong understanding of model fine-tuning - Familiarity with Python, R, or Java The project involves adapting Llama3 to our specific application, which requires significant customization. The ideal candidate should be able to work with custom datasets, and optimize this model to ensure accuracy.

...high-complexity T-SQL stored procedure used for data analysis that I need translated into PySpark code. The procedure involves advanced SQL operations, temporary tables, and dynamic SQL. It currently handles over 10GB of data. - Skills Required: - Strong understanding and experience in PySpark and T-SQL languages - Proficiency in transforming high complexity SQL scripts to PySpark - Experience with large volume data processing - Job Scope: - Understand the functionality of the existing T-SQL stored procedure - Rewrite the procedure to return the same results using PySpark - Test the new script with the provided data set The successful freelancer will assure that the new PySpark script can handle a large volume of da...

Our existing CGI...encountering issues when importing the exam's section breakdown from a .dat file. Due to this, we are unable to import the breakdown of results per section of the exam into the SQL database. We are seeking a proficient developer who can: - Analyze our existing CGI script and identify the cause of the breakdown import issue. - Provide actionable advice and steps to troubleshoot and resolve the problem. - Ensure the script effectively imports the section breakdown from the .dat file as intended. The ideal candidate for this project should have: - Extensive experience in CGI scripting and SQL database management. - Proficiency in handling and troubleshooting data import/export issues. - Ability to work quickly and efficiently, ...

I'm in need of a talented designer to create a label for my chemical and coatings product. The label will be used for product packaging. Key Requirements: - The design should be industrial in style, conveying a sense of reliability and professionalism. - It needs to be suitable for use with chemical and coatings products, so should reflect this in its visuals. Ideal Skills & Experience: - Experience in label design, particularly for industrial or chemical products. - A keen eye for detail and ability to create designs that are both aesthetically pleasing and practical. - Understanding of the importance of conveying the right message through design. This is a great opportunity for a designer looking to add an industrial label design to their portfoli...

...reading. Data Visualization: Use libraries like Matplotlib and Seaborn to create graphs showing trends in news topics or sentiments over time. Interactive Elements: Allow users to interact with the data visualizations, such as filtering views based on time or sentiment. Tools & Techniques: Web Development: Use HTML, CSS, and JavaScript for the frontend, with frameworks like React or Angular to enhance the user interface. Backend Development: Python with Flask or Django for server-side logic, handling API integrations, and user data management. Machine Learning: Use TensorFlow or PyTorch for building the recommendation engine, and NLTK or similar libraries for sentiment analysis. Data Management: SQL or NoSQL database to store user profiles and their preferences. Versio...