Sql server 2005 import csv jobs

I am in need of an individual with skills to assist with the migration of data from FS5 and .IDX files. My project involves: - files in FS5 or .IDXfiles that need to be migrated into a usable, readable CSV format that can be edited a - Handling text data specifically, and ensuring its integrity is maintained throughout the conversion. Potential freelancers need to have: - Knowledge of FS5 /.idx files. - Strong knowledge and understanding of text data management. - Excellent problem-solving aptitude, as the difficulty level can vary across files. I look forward to a thorough demonstration of your ability.

I have a CSV file that I need to be analyzed through visual data analysis in Python. The CSV file has a wide range of data, but the specifics of what data I'm interested in have been left open-ended. I need you to help me identify trends and patterns from this data and provide me with clear, insightful, and informative visualizations. Ideal skills: - Strong background in data analysis. - Proficiency in Python and data visualization libraries. - Experience with analyzing CSV files. - Ability to generate insights from data.

Looking for a skilled developer to fill in for a team member on vacation. The ideal candidate should have: - Strong experience in C# and ASP.net - Good knowledge of SQL Server The role involves: - Troubleshooting and fixing bugs in our existing applications - Enhancing and adding new features to our applications The projected timeframe for this position is less than a month, but the role could potentially be extended. You're being hired for not only your skills but also your problem-solving abilities - an essential trait when dealing with application bugs/issues. The key objectives for this role are: - Improving the performance and stability of our applications - Enhancing the user experience and application functionality Note: We skipped the outcome due to the job'...

I'm requiring aid in managing and optimizing my SQL database. This database is currently handling a range of information including product details, customer details, and order details. Key Tasks: - Improve the existing SQL database - Ensure efficient handling of product, customer, and order data Ideal experience and skills: - Proficiency in SQL queries - Experience in database management - Familiarity with inventory management processes, specifically handling a limited range of 20 different products. This project will require a keen attention to detail and a comprehensive understanding of SQL database manipulation.

I'm currently facing potential malware attacks causing unexpected slowdowns, particu...Hence, I'm in urgent need of a knowledgeable cyber security professional who can identify and rectify issues within my server files. Key Responsibilities: - Investigate the root cause for the slowdown of the website load times - Pinpoint potential malware in server files - Advance and fortify the security system to prevent future occurrences Ideal Skills: - Proficiency in cybersecurity - Solid understanding of server operations, particularly SQL - Experience in malware detection and prevention Your task: Use your expertise to bring back operational efficiency and bolster my domains server's security. If you can catch the malware predator and restore the p...

I am seeking a skilled freelancer to manage my MLS listings. Your responsibilities will include: P...projects with this developer (and of course later we will be providing details of other developer websites with their own different projects) it's important to understand that each developer will display the information in a different way so you need to know what information to look for. That's the main purpose of this first exercise….. Before bidding please look at these 2 videos showing the import of the first project “The Bliss Village”…. We have got just less than 5 weeks to get around 200 developments done.

I'm seeking an expert in PrestaShop and data migration who can efficiently perform a full data import from my current PrestaShop 1.7.5 site to the new version, 1.7.8. Specific Requirements: - Absolutly all data should be transferred. - The primary focus will be on migrating 'Customer Data' and 'Order history'. Therefore, these two areas have must be accurately and efficiently imported without loss. There are around 40 items to be imported, 900 customers. The new graphics will need to be set as per my instructions for the "warehouse" theme, The development web space for the new site is already ready with the new wharehouse theme already installed. Ideal Skills: - Proven experience with PrestaShop is a must, particularly with data migrati...

I'm seeking a SQL and snowflake expert. I have a small table in snowflake, for which I need a view to be created. The view will have some failed from the table and then some calculated fields based on the original table.  Needs to be done asap. Will share the table data and columns of the table in and excel sheet and the desired results as well for your reference.

To fill this position, I am looking for a seasoned Tableau Expert who can efficiently create a dashboard that helps in tracking and visualizing Employment Metrics. Key Project Requirements: - Connect and import data from CSV files - Visual representation of data utilizing Line charts, Bar charts, and Geographical maps - All visualizations must be designed to track Employment data pulled from a pre-existing census Ideal Experience: - Proven experience in creating interactive Tableau dashboards - Proficient in handling CSV data within Tableau - Excellent experience with line charts, bar charts, and geographical mapping - Experience in employment data analysis or HR data visualization is a distinct advantage This is a fascinating project that needs advanced skills on...

...continuously improve our data solutions Key Skills :- • Bachelor's degree in Computer Science, Information Technology, or related field. • 4-5 years of professional experience as a Data Engineer with a focus on Azure Databricks and Azure Data Factory. • Strong proficiency in SQL, Python, and/or Scala for data manipulation and scripting tasks. • Experience working with data lakes, data warehouses, and ETL processes. • Familiarity with cloud platforms (preferably Azure) and related services such as Azure Blob Storage, Azure SQL Database, etc. • Excellent problem-solving skills and attention to detail. • Effective communication and collaboration skills to work with cross-functional teams. • Azure certifications (e.g., Microsoft ...

need seo experts/developer to fix google search console/SQL index issue. we have many pages not indexed on gsc, need seo experts/developer to fix it. I'm currently facing an issue with pages on my website not being indexed and therefore not showing in Google's SEO results. It's crucial for the successful completion of this project to have these pages visible on Google again. Ideal candidates for this task should have: * Extensive experience with Google Search Console * Proven expertise in resolving indexing issues * A deep understanding of SEO best practices Please include your past work related to resolving such issues in your application. A detailed project proposal would certainly be a plus. Prompt completion is advantageous, although a precise timeline has...

...large Telegram channel and groups. The ultimate goal is to invite these subscribers to my own channel. Key Results: - Extract or scrape customer data from specified Telegram channels or Groups. - The type of data required is mainly (phone number - user) - Extracting data from private channels or groups - Provides a complete list of extracted customers - Ensure customer data is ready to easily import into my channels for invitations Ideal Skills & Experience: - Proficiency in web scraping tools and techniques - Experience with Telegram algorithms - Experience with Telegram API or similar platforms - Proven track record in handling and managing large amounts of data - Strong communication skills to provide detailed project proposals Please ensure that your application contai...

I'm in need of an experienced Python developer to assist with the development of critical web security tools. While specific tools aren't outlined below - Subdomain Enumeration: Subdomains to be listed and categorized. - Directory Enumeration - Sensitive Parameter Detection - XSS Testing - SQL Testing

I'm in need of a skilled developer with expertise in Yii framework to add new functionality to our existing system that serves a financial services purpose. The successful candidate will be responsible for implementing the following features: - Add menu new menu items using the language file - Bank statement mapping - Bank statement import - Bank statement transaction allocation A full specification is available for the selected candidate. Ideal skills and experience for this job include: - Proficiency in Yii framework - Strong PHP skills I look forward to your proposal for this project.

I'm in need of an experienced Python developer to assist with the development of critical web security tools. While specific tools aren't outlined below - Subdomain Enumeration: Subdomains to be listed and categorized. - Directory Enumeration - Sensitive Parameter Detection - XSS Testing - SQL Testing

I'm seeking a skilled Drupal expert to help me to export form submissions from the Drupal website to csv More details will share I can able to download as json file. I can able to download as yml file. But only CSV is blocking. So iwant CSV export web form Ideal Skills and Experience: - Proficient in Drupal CMS - Prior experience setting up content management systems - Ability to tailor CMS systems to specific business needs - Good communication skills to ensure our team can effectively use the CMS.

Example link: I require the capture/extraction of 84x numerical values (table comprises of twelve events, seven results p...PDF file as quoted above. There will be 1,000s of unique PDF's, so my guess is I'd copy/paste relevant addresses into an Excel file and a Python script would run from there (?). To my knowledge, PDF file is always four pages in length, relevant table to scrape is always located on page2. Required data is always located in the same position/same column in PDF files. (Possible) example output in CSV/Excel could look like: date | 1H | 21,114,900 | 291,000 | 719,400 | 119,200 | 71,000 | 17,900 | 12,600 That output line (above) would have twelve lines of data per daily PDF file (1H, 2H, 3H etc)

I am seeking a skilled freelancer to guide me in creating Power Automate flows that efficiently import data from a single worksheet Excel document into Dataverse. Key Tasks: - Develop a couple of Power Automate flows to import Excel data into Dataverse. - I have had many difficulties with date and lookup/choice columns not correctly importing. Ideal Candidate: - Expert knowledge and experience in Power Automate. - Proficient in Data Integration between applications. - Knowledgeable in creating approval workflows and automated notifications. - Previous experience with Excel-data integration into Dataverse. - Excellent communication skills.

...seeking a highly skilled data engineer with a strong proficiency in Apache Kafka to work on a data integration project. The main objectives of this project are: - Integrate various data sources: structured (SQL database), semi-structured (XML, JSON), and unstructured (emails, documents) - Develop a robust data flow architecture - Ensure efficient data transmission across systems The perfect freelancer for this job should possess the following characteristics: - In-depth knowledge and practical expertise with Apache Kafka - Experience with integrating diverse data sources, such as SQL databases, XML, JSON and unstructured data (emails, documents) - Proven track record of successful data integration projects Feel free to schedule a meeting using this link.

...customer segmentation strategies. As such, the project will require a deep understanding of customer behavior and sales patterns. - **Data Type**: The data provided for this project is structured, primarily in Excel and CSV files. Your ability to effectively manipulate and analyze this data will be crucial. Ideal Skills and Experience: - Proficiency in Azure and strong experience in running ML models on the platform - Proven track record in customer segmentation and sales data analysis - Ability to work with and manipulate structured data effectively, particularly in Excel and CSV formats I'm looking for someone with a solid understanding of sales data and a keen eye for customer segmentation. If you're confident in your ML skills and Azure proficiency, I'...

We are engaged in the bag industry import and export supplier of the company, is committed to providing customers with more cost-effective bag production services. Now we need an engineer to help us build a company promotional page, which is required to meet the aesthetics of European and American customers. If you are good at it and interested in this job, welcome to contact me and communicate the design details. Please confirm with a reply starting with Hello World.

... Non-functional Requirements: 1. Security:  Implement HTTPS for secure communication.  Apply role-based access controls to restrict unauthorized access to sensitive data.  Regularly update and patch software components to address security vulnerabilities. 2. Performance:  Ensure fast loading times and responsiveness of the website, even under heavy traffic.  Optimize database queries and server-side processing for efficient performance. 3. Scalability:  Design the system to handle a growing number of users and transactions over time.  Employ cloud-based infrastructure to scale resources dynamically as needed. 4. Compatibility:  Ensure compatibility with popular web browsers (e.g., Chrome, Firefox, Safari).  Support responsive design for seamless user experience acros...

I have C# MVC Web App that works using SQL Server Database & using APIs at the same time. For the functions that use the database, I want to replace them with the APIs 1- Error message appear with no details, need to make the error message has Show More to display the details of the error. 2- Load Codes from APIs instead of loading from JSON file. (1 API) require updating treeview to load on demand 3- Packages Load from APIs instead of loading from DB (2 APIs) 4- SubscribedPackages Call API instead of inserting into a DB (1 API) 5- Schemes Load from APIs instead of loading from DB (1 API) 6- Uploads Call API instead of inserting into a DB (1 API) 7- Users Call API instead of inserting and reading from a DB (5 APIs) you must have C# MVC experience. -----------...

I am seeking a highly skilled freelancer to undertake a multifaceted project involving the detailed completion and enhancement of a CSV file for upload to Square. This extensive project requires three core competencies: meticulous data extraction from our website, proficient data entry into an Excel form, and the creation of engaging service descriptions using AI tools. The ultimate goal is to craft a CSV file that not only meets but exceeds the requirements for Square's platform, ensuring a seamless upload process. Key Responsibilities: Data Extraction and Accuracy: Initiate the project by extracting data from specific sections of our website. This data must be accurately transcribed into an Excel form, adhering closely to the required fields. Attention to detail is p...

I have a Java application currently running on Java 8 that demands an urgent cert...application currently running on Java 8 that demands an urgent certificate update. The application connects with an AWS RDS instance using PostgreSQL and current requirements necessitate an upgrade to a new certificate. Upon successful import and upgrade of the new cert in the AWS environment, the change then needs to be effectively verified through a manual testing process. Skills & Experience required: • Profound understanding of and substantial experience in Java 8 • Experienced working with AWS RDS (specifically PostgreSQL) • Capable of certificate upgrade & import in AWS • Well-versed in manual testing procedures. Please, only submit a proposal if you ca...

Hello, I have android app (check attachment), i need to send and request data to it's server by using Postman instead of using the app. I was able to do it before the app's developer using HTTPS on their API call to it's server. This new app version seems like it's encrypting the data, but i believe the encryption/decryption key hidden inside the app it self. If you think can work on this project and achieve my goal, please bid on it. Any further question should you ask me so i can explain more detail. Thanks

I'm in need of a skilled proofreader who is familiar with APA citation style to review and edit my 1200-word essay on the 2005 Avatar: The Last Airbender series. The task involves fixing grammatical errors, ensuring coherence, and most importantly, filling in the blank spaces with proper APA style citations. A deep understanding of the show would be an added advantage. Or Writing a 1600-1800 word argumentative essay on either student loan debt and cost of education or low minimum wage. You may pick which topic and must be written with 4-5 sources 2 of which I will provide as it must come from my schools online library and cited in APA format. Key Requirements: - Proofreading skills - Proficiency in APA citation style

I'm in need of a specialist in MongoDB who can effectively troubleshoot and resolve configuration errors that I've encountered during its reinstallation on my Ubuntu Apache server. I'd appreciate bids from candidates who, at a minimum, possess the following qualifications: - Expertise in MongoDB installation, setup, and troubleshooting - In-depth knowledge of Ubuntu Apache server management - Strong experience in handling configuration-related issues - Bonus: Understanding of file path, authorization, and networking issues, as the specific type of configuration error wasn't determined Please be ready to detail your relevant experience and strategies for resolution. Thanks!

I am seeking a skilled freelancer to guide me in creating Power Automate flows that efficiently import data from a single worksheet Excel document into Dataverse. Key Tasks: - Develop a couple of Power Automate flows to import Excel data into Dataverse. - I have had many difficulties with date and lookup/choice columns not correctly importing. Ideal Candidate: - Expert knowledge and experience in Power Automate. - Proficient in Data Integration between applications. - Knowledgeable in creating approval workflows and automated notifications. - Previous experience with Excel-data integration into Dataverse. - Excellent communication skills.

I'm launching an import and distribution enterprise and require an impressive, eye-catching logo that captures the spirit of our new business. The logo's color scheme must include Red, White, and Blue and incorporate a "Star" symbol. Although our business focus is global, our primary target markets will be Chile, New Zealand, Australia, and China. Key Qualities To Reflect In Design: - Innovation - Reliability - Stability - Trust - Confidence Skills & Experience: - Previous experience in designing logos for startups or import/export businesses. - Strong understanding of color theory and symbolism. - Ability to effectively incorporate symbols into design. - Proficiency in contemporary design trends. - Familiarity with cultural nuances of our target mar...

I'm seeking an experienced Google Script specialist to automate tasks and manage data for my project. Here are the specifics: Automating tasks: Your main responsibility will be to automate data import/export processes using Google Script. I need to take the data attahed to a daily email in excel format, upload this data (and historic) to a data base and then allow to consult that data from different spreadsheet in google with a query. Ideal skills and experience include: - Proficiency in Google Scripts and automation - Experience in data management - Google spreadsheet analisis reports If you have the needed expertise, I'm excited to work with you!

I am looking for a skilled freelancer, adept in ETL (Extract, Transform, Load) operations. In this project, your task will be to extract CSV files from an SFTP server and load them onto a SharePoint Document Library. Key responsibilities: - Source the data from the SFTP server. - Ensure accurate and smooth extraction of CSV files. - Successful Load of the data to SharePoint Document Library. Ideal candidate skills and experience: - Solid background in ETL operations. - Prior experience with SFTP servers. - Proficiency with working CSV files. - Familiarity with SharePoint Document Library.

I'm in need of assistance for importing physical products to my WooCommerce store. The main requirements of the project are as follows: - **Product Import:** I have a feed of physical products that need to be imported into my WooCommerce store. - **Filtering:** These products should be filtered based on their category before being imported. - **Product Updates:** Once imported, the system should update product prices and stock regularly, and add any new products to the store. This process should be automated and occur every hour. I'm looking for a freelancer with the following skills: - Strong experience with WooCommerce, including product importing and updating - Proficiency in creating smart filters for product selection - Automation expertise to ensure product upda...

...skilled developer who can create a chat client-server program . The focus should be specifically on enabling text messaging and group chat functionality. The Language for this project is Python 3 You should write a client program and hence a client process should be running. Also. You should write a server program and hence a server process should be running. Specifically, you must implement two independent applications. One, called chatClient, implements the client component. The other one, called chatServer, implements the server component. You must design your own protocol for the communication between the client and the server. Key Features: Basic Functionalities • Administration Capabilities o A client will start by contacting the serve...

I'm urgently looking for a web scraping expert who can help me gather information from various medical service p...names, contact information, medical service details, and additional data such as phone numbers, specialties, and participating plans. - The information should be pulled from three specific websites - Website 1, Website 2, and Website 3. Your deliverable: - The scraped data should be compiled into a CSV format for easy analysis and integration into our system. Ideal Skills: - Proficient in web scraping and data extraction - Advanced knowledge in handling and exporting data formats like CSV - Experience in scraping medical websites or similar domains would be a plus. Please bid only if you can start immediately and provide a quick turnaround on this urge...

...Existing Environments. Maintain Documentation For System Processes And Procedures. Participate In Code Reviews, Contribute To Team Knowledge, And Mentor Junior Developers. Required Skills: Strong Proficiency In Perl Scripting And Python Programming. Experience With XML Technologies, Including XML Parsing And XSLT Transformations. Good Understanding Of Relational Database Management Systems And SQL. Excellent Problem-Solving Skills And Ability To Think Analytically. Strong Communication And Interpersonal Skills, With An Ability To Communicate Complex Concepts To Non-Technical Stakeholders. Additional Qualifications: Experience With Web Technologies (HTML, CSS, JavaScript) Is A Plus. Familiarity With Software Development Methodologies Such As Agile/Scrum. Perks And Benefits:...

...product, then complete the purchase on our platform. Key Features: - Seamless Integration: Our site seamlessly integrates with major marketplaces like Amazon. - Automated Purchases: Once a user selects a product, our site automatically processes the purchase. - Dynamic Pricing: The site detects the user's country, calculates delivery costs, and adds a commission. - Dropshipping Model: We do not import products; instead, we display them directly from the marketplace page using iframe HTML tags. We prefer to build the site using WooCommerce or WordPress for flexibility and ease of management. **Requirements:** - Proficiency in WooCommerce/WordPress development. - Experience with iframe HTML tags and dynamic pricing. - Ability to integrate with major marketplaces. - Underst...

I'm in need of a skilled freelancer to set up and install Primavera P6 EPPM 21.12 locally on Windows. This is a single user setup, with SQL database configuration included. Key Tasks: - Install Primavera P6 EPPM 21.12 on a Windows system - Complete and configure the SQL database for the software Ideal Freelancer: - Experienced with Primavera P6 EPPM installations - Proficient in SQL database setup and configuration - Understands the intricacies of Windows OS - Prompt and clear in communication

You are asked to create an Excel file (FILE A) that: 1) Automatically extract data from another Excel file (FILE B) which is located in an FTP folder and which is updated every day. 2) The FILE A must extrapolate the data from the FILE B based on some filters that can be set or changed. For example, a filter could be the Brand or the Price. 3) The output (FILE C) of FILE A must be a .CSV file composed of 3 columns: SKU, Quantity and Price. 4) The final part is that this FILE C is saved inside another FTP folder. This entire 1+2+3+4 process must be done automatically every day at a certain time without the intervention of an operator.

...address and make a payment. Rating page. Users will be prompted to login before accessing this. Star ratings will be filled in here, and the welcome text will have each users [first_name]. Generate a custom QR code to a rating page with pre-filled order number (unique identifier from above) Order confirmation email. With animated banner and QR code. SQL database. All data from the users, questionnaires, orders, and ratings will be stored in a postgres SQL. I have specified the database design (see below). Currently there is no API to warehouse/shipping (postage of orders are handled manually, but please set up the database with the future API integrations in mind). Manual order (in backend). Basically, I want to be able to look at the sample ratings for each sample order a...

I'm in search of a skilled machine learning developer with expertise in GPT (Generative Pre-trained Transformer). My goal is to have an AI model that can both correct and standardize postal addresses. The addresses will be provided in CSV files and the output of the model should be accessible via an API for integration into our system. Key requirements: - Proficiency in machine learning with a focus on GPT - Experience in addressing data correction and standardization - Ability to work with CSV files - Familiarity with API integration - Strong communication skills for seamless collaboration The ideal candidate will have a proven track record of developing AI models, particularly in the realm of addressing data, and be able to provide a detailed timeline for the complet...

...air pollution modelling using RStudio. The primary tasks for this project include: - Data Collection & Analysis: I need help in collecting relevant data on air pollution and subsequently analyzing it. - Result Visualization & Interpretation: After the data analysis, I require support in visualizing the results and interpreting them. The data that will be provided to you for this task will be in CSV format. Therefore, you should be well-versed in handling and analyzing data in this format. The ideal candidate for this task should have a strong background in data analysis, particularly in the context of environmental science or air pollution. Proficiency in RStudio is a must, as this is the primary tool that will be used for the modelling activities. Your role in thi...

can you help me with pass ookla host-tester PFA

I'm in search of an individual familiar with iris elements to assist with troubleshooting issues concerning logging in with HMRC for VAT. My situation requires: - Mastery in how to operate the iris elements' functionalities for data import, analysis and reporting, and visualization. - An impressive level of experience dealing with issues related to logging in with HMRC for VAT. - A sound understanding and working knowledge of the VAT account features on the HMRC platform. While I do have an existing HMRC account for VAT, I am currently facing difficulties. The project's essence is to resolve this issue, optimally with minimal impact on my VAT returns activities. If you find your skills in alignment with my needs, please freely bid for this task.

I'm in need of a skilled .NET developer to create...additional integrations may be required in the future. Experience with integrating external systems and APIs would be beneficial. - User Roles and Permissions: The application may need to support multiple user roles and permissions. While this is currently marked as 'unsure', the ability to handle this efficiently would be a plus. Ideal Skills: - Proficiency in .NET development - Strong knowledge of SQL databases and data management - Experience in user authentication and registration systems - Previous work involving user role and permission management - Flexible to adapt and integrate external systems when required If you're a skilled .NET developer with a track record of creating user-centric web applicatio...

Dears, my hostinger Ubuntu Server with cloud panel Down on Hostinger. Need your quick support.

I'm in need of an experienced developer to bring my SQL codes with the triggers to life with a well-designed Apex Oracle application. The app is expected to have the following features: - Implementing data entry forms that are intuitive and user-friendly. - Developing robust data analysis reports that provide valuable insights in an easy-to-understand format. - Setting up a comprehensive user authentication and security system. - Creating a visual design that aligns with my company's corporate branding while also being colorful and vibrant. - Ensuring the application is responsive and works seamlessly on both desktop and mobile devices. - Implementing an efficient navigation and information architecture to enhance user experience. The ideal candidate for this project sho...

I'm in need of a skilled web developer highly experienced in both Angular and Javascript. The primary objective for this project is to create a website with a responsive design that aligns with my provided brand guidelines. Key Qualifications: - Proficient in Angular and Javascript - Extensive experience in responsive design - Extensive experience in .Net Core and SQL Responsibilities: - Adhere to design and branding guidelines during web development - Create a website that is user-friendly on all devices. Please ensure to provide examples of past work with responsive web design during your application.

...applications, with the aim to identify and eradicate any potential vulnerabilities. Key Tasks: - Perform Open Source Intelligence (OSINT) - Port scanning - Man-in-the-middle (MiTM) attack simulation - Focus intensively on injection attacks (SQL, XSS) - Authentication and session management puncturing - Cross-Site Scripting (XSS) evaluation The ideal freelancer will have: - Strong experience in cybersecurity and penetration testing - Excellent knowledge and experience with Linux-based systems - Proven experience in web application security testing - Firm understanding of SQL, XSS and authentication vulnerabilities Your final deliverable will be a complete penetration testing report, detailing vulnerabilities found, their potential impact, and recommended remediation step...

As a client, I'm seeking a seasoned data analyst with expertise in data science who can thoroughly clean, preprocess, and visualize a dataset sourced from CSV files. The chosen candidate: - Should first start with cleaning and preprocessing the data to create a reliable foundation for analysis. - Should then interpret and present that same data through meaningful visuals to explore its intricate properties and characteristics. - Should additionally facilitate statistical analysis to derive patterns and trends otherwise invisible to the naked eye. The hoped-for end-product of this project is not just predictive analytics but insight and data-driven recommendations that will inform future decision-making. Proficient use of Python or R for these tasks is essential, as is familia...