개인적으로 교육연구에서 자주하는 (통계)분석 몇 개를 자동으로 할 수 있는 간단한 R 패키지를 만들고자 합니다. 테스트데이터(Treatment/Control 그룹 사전/사후 데이터 셋(csv 파일)을 종류별로 인식하여 읽어들이고, 사전데스트/사후데스트로 구분할 수 있게 변수명을 바꾸고 (예: 수집된 데이터 문항 Q1, Q2, Q3...로 되어 있는데요, 사전테스트 데이터면 Q1_pre, Q2_pre, Q3_pre...로, 사후데이터면 Q1_post, Q2_post, Q3_post...로 변환), 해당 데이터별로 제가 이미 만들어 놓은 스크립트를 돌려 (Item Analysis, ANCOVA 등의) 분석을 자동 시행하고 결과를 출력하도록 하는 간단한 패키지입니다. 데이터셋을 종류별 구분해서 읽어들이는 것이 관건인데, 제가 이 부분에서 애를 먹고 있는 중입니다. 사용자로부터 (treatment pre, treatment post, control pre, control post) 인풋을 받아 If, For 등의 Function을 쓰면 될 듯 한데 (저의 짧은 소견입니다^^;), 제가 아직 R 함수에 익숙치 않아 주로 이 부분을 R 전문가의 도움을 받고자 합니다. 구체적으로 무엇을 구현하려고 하는지는 지금까지 제가 만들어 놓은 스크립트와 관련 문건들을 파일로 참고하시면 되실 듯 합니다. 다시 한번, 도움주실 내용의 핵심은 4종류의 데이터셋을 구분하여 읽어들이는 스크립트/함수가 되겠고요, 두번 째로 중요한 것은 스크립트가 완성되면 분석별로 스크립트를 묶어 함수화하는 것이 되겠습니다. 참고로, Item ...
The mssql database you are currently using is slow to search You want to improve the speed of this slow search speed.
I'm looking for an experienced freelancer to tackle data entry. The focus is on text data, which needs to be accurately inputted into a structured database. While attention to detail is important, issues checking for spelling or grammar errors will not form part of the job scope. In line with this, the ideal candidate should: - Have a proven track record with data entry projects - Have expertise in structured databases - Be able to work accurately with text data - Have the ability to complete tasks effectively within the given timeline.
...various types of media files. The ideal freelancer for this project would have a solid understanding of Python, machine learning, NLP, and experience with BERT models. Features of the Python Script: - Process text queries obtained from a CSV file (example CSV attached) - Detect entities such as: - Persons - Places - Events (e.g., weddings) - Dates - Number of individuals visible - Media type (Image, Video, Audio, Text) - Detailed type (Interview, Landscape, Close Up, Group, etc.) - Length - Content - Retraining should be based on a provided CSV file containing Sentence, Entity, and IOB Tagging training data. The model does not need to be trained - only provide the capability. I am looking for a detailed and accurate script that can efficiently...
I am looking for a database website that serves as a customer form. This form will be used by customers to fill in various fields. Upon submitting the form, they will automatically receive a comprehensive response based on the information they provided. Key Requirements: - The customer form should include fields for Name, Contact information, Address, Location, Product or Service details, Width and Height, Dimensions, and Vertical or Horizontal preference. - The form should have an inbuilt auto-calculation feature that computes the Total cost, based on the area calculated, and any additional amount based on the customer's requirements. Delivery of Reverted Information: - The system should trigger an automated response to the customer. This can be in the form of an Email, a We...
I need a skilled Prestashop 1.7 expert for my project. I am specifically interested in customizing my product catalog. The main task will be: I need to add Display Condition on Product Page by default i use csv. I need to add extra product condition thats it 2 small works
I have a database that I need to be cleaned up. The main task is to remove duplicate entries. Key Points: - Main Task: The primary goal of the data cleaning project is to remove duplicate entries in the database. - Handling Duplicates: The duplicates should be automatically deleted, not merged or manually reviewed. Ideal Skills & Experience: - Database Management: A strong background in database management is crucial for this task to ensure the data is processed correctly without compromising the database integrity. - Data Cleaning: Experience with data cleaning processes, especially in handling duplicate records, is important. - Automation: The ability to automate the deletion of the duplicates efficiently and accurately is essential. Please bid...
I urgently require a thorough cleanup of my contact database. The main tasks include: - Verification of the correctness of email addresses - Authenticity check of RUTs - Verification of phone numbers The right candidate for this project should possess excellent attention to detail and experience in database management, particularly in contact cleaning. Familiarity with RUT verification will be highly valued. Please apply only if you can start immediately.
...program to upload and save attachments Description: I created a program that uses HTML, CSS, and Javascript to enable patients to fill out their information, including the option to attach files. Upon submission, a PHP script is triggered to email the data to me as a CSV file. The attachments (typically JPEG’s or PDF’s) uploaded by the patients are not being included in the email. Objective: Adjust program to upload and transmit attachments with .csv Deliverables: - Updated program with ability to transmit attachments in csv - Documentation of all changes with code (unrestricted) - Format attachments as: o Insurance-patient’s last name-patient’s first name o ID- patient’s last name-patient’s first name Attachments: The HTML,...
I'm looking for a Kotlin developer with experience in migrating applications from local Realm to MongoDB Realm. The current status of the app is fully developed, and I'm only interested in converting the local Realm database to the MongoDB Realm database, without any additional feature or minor changes. The ideal candidate should: - Be proficient in Kotlin - Have experience with Realm - Have experience with MongoDB Realm - Understand database migration processes and best practices
I'm in need of an expert to optimize my WordPress database speed. The current issues I'm facing involve slow loading times and prolonged database queries. The following tasks are essential for fixing the site's speed: - Updating and optimizing plugins: The site is currently slowed down by outdated plugins. An experienced professional should be able to update and optimize these plugins to enhance the site's performance. - Database performance improvement: As my priority lies in improving database performance, the freelancer should focus on database queries and other related optimizations to ensure the site runs smoothly and efficiently. - Site speed score: The ultimate goal is to achieve a site speed score above 95. The hired individua...
i need menus extracted from a webpage the most important columns (data points) will be category name product name, product price, product description.
I need a professional to scrape specific details from a website directory for a one-time project. - Specifics: The data of interest includes the company names, their URLs, and their expertise. This information is laid out in rows on the website. - I wish for the freelancer to carefully extract this data, ensuring no errors or omissions are made. - The final output is essential to be in a CSV file format. I require this scraping to be done just once, and I do not foresee a need for ongoing scraping after this initial task. As the data is crucial for my business development, I am seeking someone who can deliver accurate and complete results in a timely fashion. Prior experience with web scraping and proficiency in data management are highly desirable.
I'm currently encountering connectivity issues with my existing Azure Virtual Networks specifically with connecting to the MySQL database. I have a main Vnet with my mysql database in there. I have a virtual machine in there too which can connect to the database I have a second vnet which is peered to the main vnet. I have a virtual machine in this vnet too. It can talk to the virtual machine in the main vnet, but cannot connect to the database. I need it to be able to, and I cannot figure out why. You can tell me how to do it and I can test, this doesn’t need to be a long project!
I need a PowerBI specialist for uninterrupted data extraction, processing, and visualization for our existing business operations. I expect you to be proficient in dealing with CSV files, Microsoft Excel, and Tally, as these are the main data sources in our operation. Core responsibilities will be: - Setting up PowerBI to pull data from these sources - Creating meaningful data visualizations that help us make informed business decisions. While we're not yet sure how frequently we'll need data refreshes in PowerBI, you should be prepared to advise us on best practices based on our data volume and usage trends. Thus, familiarity with handling versatile data flow frequency is a must-have. Experience in similar projects and excellent communication skills will be hugely ben...
I need an expert to help with advanced troubleshooting and optimization for my Oracle database. The ideal candidate should have: - Proven experience in database administration. - Proficiency in Oracle database. - Expertise in database troubleshooting and performance optimization. - Adept in using SQL Developer for managing database tasks. You'll be handling tasks such as: - Identifying and resolving performance issues. - Suggesting and implementing optimizations. - Monitoring database activities to ensure smooth operations. Your role will be crucial in ensuring the efficiency and security of our Oracle database.
I've been assigned the task of building a web application where users can input company names, and any public...initially explored utilizing an [API from ](), I encountered difficulties with downloading data or obtaining an API key, possibly due to issues with their website. but was able to find [this csv file on kaggle]() containing information of companies from 1857-2020. My initial approach is to use appwrite for backend and react for frontend. populate the appwrite db with information from the csv file. then build the react frontend. however I can't help but wonder that there must be an easier way to do this. How would you make this?
I am in need of a skilled data entry operator to assist with the transfer of input of text data. Your main task is to take text data from an online database and accurately enter it into an Excel spreadsheet. Requirements: - Ability to accurately enter text data - Proficient in Excel - Experience sourcing data from online databases - Diligent and detail-oriented to ensure no errors are made during data transfer - Strong English language skills to ensure effective communication The ideal freelancer for this project is someone with proven data entry experience, excellent Excel skills, and vast familiarity with online databases. Being a detail-oriented person with great concentration skills will be a huge plus.
✔Project Overview: We are seeking to develop a program that reads QR codes from multi-page PDF files and image files provided by our clients and extracts that data into CSV files. Due to format differences, existing AZURE OCR API have not met our requirements, necessitating a custom solution. ✔Specific Requirements: 1. Ability to read QR codes from multi-page PDF files, multiple PDF files, and image files such as JPGs and PNGs. 2. Capability to analyze the data within the QR codes and format it into CSV files. 3. Development must be done in either Python or JavaScript. ✔Skills Required: -Experience in development with Python or JavaScript. -Knowledge of OCR technologies and QR code reading techniques. -Experience in handling PDF and image processing. ✔Project Goals: The go...
Here is a list of zip files on a US Govt website. You must write a Python program that uses a network library to download each zip file on this site, then find each .csv file in the zip archive, and copy each .csv file in each zip archive to a hard drive directory on the local windows machine. The directory will be "C:/MedicareDownloadFiles". The files cover the years 2017 to 2024. You may not hardcode file names ... you must extract the filenames from the above https URL. The fee for this will be $30. You must have it done within 60 minutes. Thanks for participating!
Here is a list of zip files on a US Govt website. You must write a Python program that uses a network library to download each zip file on this site, then find each .csv file in the zip archive, and copy each .csv file in each zip archive to a hard drive directory on the local windows machine. The directory will be "C:/MedicareDownloadFiles". The files cover the years 2017 to 2024. The fee for this will be $30. You must have it done within 60 minutes. Thanks for participating!
My project requires the assistance of an experienced data analyst or data miner. I'm working on a market research project, which requires the extraction of text data from a specified website. Here are the specific details: - Task: Extracting text data from a website for data analy...experienced data analyst or data miner. I'm working on a market research project, which requires the extraction of text data from a specified website. Here are the specific details: - Task: Extracting text data from a website for data analysis - Output: All extracted text data should be provided in a CSV file Given the nature of this project, prior experience in web scraping, data extraction, or data mining is highly desirable. The ability to accurately extract data and transfer it into a ...
...Oracle 19c database through JDBC. The primary goal of this project is to incorporate essential data operations into the application, mainly including reading, writing, and updating data in the database. Key Responsibilities: - Establishing a secure connection to an Oracle 19c database using JDBC. - Implementing CRUD operations (Create, Read, Update, Delete) features within the application. - Ensuring the application is optimized for efficient data handling and processing. Security Requirement: - The application must be able to securely access the database using username/password authentication. Ideal Candidate: - Proficient in Java and Springboot framework development. - Experienced with Oracle database SQL and JDBC connectivity. - Prior experience...
We are looking for a MILVUS devOps expert who will know how to recommend and install the best Milvus hosting server. We are also looking for someone who has done this before MANY MANY times. The end goal is to 1/ recommend which Milvus install plan is best (K8, simple Docker, etc...) 2/ install Milvus and 3/ write detail documentation on how it was done. Then we may want to give you the chance to support and maintain the install. FOR us to consider your submission (WITHOUT the answers to these questions your submission will be automatically deleted) Question 1: Please let us know how many times you have configured and install Milvus. Question 2: Please describe the best architecture you recommend to install and host Milvus. Question 3: Will you be able to demo at leas...
...Generating CSV or Text files: The extracted data should be organized and formatted into CSV or TXT files. Each property in the system should have its own file containing the relevant data. - Uploading to FTP: The generated files should then be uploaded into our FTP as individual files for each property. Ideal Skills and Experience: - Proficiency in API integration: Prior experience with integrating various API’s is crucial for this task. Particularly, experience with Tehama, Cereniti, and Inovonics API’s would be highly beneficial (documentation for the reading systems in question is available for reference if you are not familiar). - Data handling expertise: Strong understanding of data processing and manipulation is necessary for organizing and formatting...
I'm looking for a skilled Excel expert who can help with adjusting product pricing, adding products, creating formulas, adding products etc via excel, .csv. This is a ongoing project. If you can upload .csv to wordpress is a big plus!! KEY REQUIREMENTS: - I specifically need assistance with spreadsheet automation. - The work required is at a basic level, focusing on formulas and functions. - Implement automation for the designated tasks. - Ensure that the automation is robust and well-documented. SKILLS & EXPERIENCE: - Proficiency in Excel is a must. - Experience in basic spreadsheet automation. - Strong understanding of formulas and functions. - Attention to detail and commitment to quality.
I am in search of a proficient data entry specialist to integrate data into my online Microsoft Access database. Key Responsibilities: - Entry of a large volume of data accurately and efficiently - Verify the integrity of data before entry into the database Ideal Skills and Experience: - Proficiency with Microsoft Access - High attention to detail, precision and excellent organizational abilities - Prior experience with large database data entry is a plus Please note, the spreadsheet format requirement was skipped and so any standard format is acceptable. Only apply if you are proficient, accurate, diligent, and can meet deadlines.
I'm looking for an experienced PHP developer to work on a new E-commerce website. The project involves: - **Website Development**: You'll be responsibl...E-commerce website. The project involves: - **Website Development**: You'll be responsible for creating a complete E-commerce platform. This includes setting up the necessary pages, product listings, and a user-friendly interface. - **Database Management**: Besides building the site, you'll also be in charge of managing its database. This involves ensuring data integrity, proper storage, and efficient retrieval. Ideal candidates for this project should have: - Proven experience in PHP development, specifically in E-commerce platforms. - Strong database management skills. - Understanding and e...
I'm in need of a professional who can efficiently handle data entry tasks into a database. The source of the data will be a mix of physical documents, digital files, and potentially web sources. Key Requirements: - Experience in online data entry. - Proficiency in database handling. - Strong attention to detail. - Ability to work with a variety of data sources. Your primary responsibilities will be: - Entering data accurately into a database from various sources. - Ensuring the integrity of the data being entered. The ideal candidate should be able to demonstrate a high level of focus and accuracy while working at a reasonable pace.
...have less than 10 columns, as I believe this will keep the sheet concise and easy to manage. The level of automation I am looking for is manual data entry with some formulas. This will help reduce manual work and ensure the data input is accurate. Ideal skills and experience for this job would include: - Proficiency in Excel: A deep understanding of Excel and its functionalities is essential. - Database Management: Experience in handling databases will help in setting up the product list and other related data. - Inventory Control Knowledge: Understanding of inventory control principles is a plus. - Report Generation: Experience in creating reports in Excel will be beneficial. Your goal is to create an efficient, user-friendly, and reliable Excel sheet that will help me manage...
Hi Murat K., Need to have a fix the CSV conversion to the file. Need to add 2 extra fields to be pulled from the CSV file and inserted into position in the file.
...making some changes to the the user interface of my healthcare database website. The primary goal of the changes is to significantly enhance the user experience and make it more userfreindly. This is not a "redesign" task! The staff have learnt how to use the database and I don't want them to have to need to learn their way around a whole new database... not requesting any major changes, but a few points which are mostly related to the way the information is displayed not being user friendly. I need specific changes made. Please see document attached. I'm hoping to work with someone who has experience in both database website development and user interface design. It's important to me that you understand that the way the databa...
I'm looking for an experienced coder to develop a script that can scrape dynamic websites. The script should be capable of sifting through an input CSV list of URLs, and obtaining both text content and links based on specific URL criteria.
I have a database that I need to be cleaned up. The main task is to remove duplicate entries. Key Points: - Main Task: The primary goal of the data cleaning project is to remove duplicate entries in the database. - Handling Duplicates: The duplicates should be automatically deleted, not merged or manually reviewed. Ideal Skills & Experience: - Database Management: A strong background in database management is crucial for this task to ensure the data is processed correctly without compromising the database integrity. - Data Cleaning: Experience with data cleaning processes, especially in handling duplicate records, is important. - Automation: The ability to automate the deletion of the duplicates efficiently and accurately is essential. Please bid...
I have a project that involves entering text data from printed documents into a database. Ideal Skills and Experience: - Proficiency in data entry and accuracy in transcription - Experience working with printed documents - Knowledge of database management - Attention to detail to ensure complete and accurate data input Key requirements for the job include: - Efficiently entering text data from printed documents into a database - Ensuring the highest level of accuracy in transcribing the information - Organizing the data in the database in a logical and coherent manner - Completing the task in a timely manner without compromising accuracy. Your understanding of the importance of this task in the overall project and your commitment to quality and efficiency w...
Necesito algún programador que tenga algún tipo de experiencia con el protocolo MDB a fin de crear una interfaz que pueda entender MDB y traducir la comunicación para poder interactuar con un POS de Transbank. Todo esto para integrar pagos con Transbank en una Vending Machine que utiliza el protocolo MDB a través de una aplicación en Android.
I am in need of a professional to convert a CSV file with about 3000 lines into a .sql file, ready for flawless loading into a MySQL database. THIS HAS TO BE DONE WITHIN THE NEXT 60 MINUTES. PLEASE DO NOT BID UNLESS YOU CAN DO IT IMMEDIATELY. THANKS. Payment will be $25. US Key tasks: - Convert provided CSV file into a .sql file - Ensure Date/Time values are formatted according to MySQL Date/Time format - Format numeric values as FLOAT within MySQL - Configure date/time values to match my local timezone Skills & Experience: - Proficient in SQL - Experience with MySQL databases - Attention to detail and accuracy Understanding of Time Zones would be a complimentary bonus. This project requires quality and accuracy. Thanks in advance for your valuable bids.
I'm seeking a skilled developer to help build a dynamic and secure social registry database. The primary purpose of this database will be to store specific categories of user information, making it a critical data backbone for our social business operations. Key features will include: - Storage of Personal Identities: User's demographic and identity-related data. - Interaction Histories: Tracking user interaction data for better service delivery. - Location Data: Storing user location data to improve geographically targeted offerings. Moreover, I envision a flexible data entry process encompassing: - Manual Data Entry by administrators: Option for admins to input data manually, ensuring the correct configuration and verification of user information. - Automated Da...
I'm in need of a VBA Excel expert to assist with generating weekly financial reports. Key Requirements: - Weekly Reporting: The expert should be able to create efficient and accurate VBA scripts that will automate the generation of excel charts based on our csv files reports downloaded from our service management software on a weekly basis. The chart is basically to display the Technician's daily sales of labour and material sold (shown in separate charts. - Financial Data: These reports will be based on our financial sales data, so the expert should be comfortable working with and manipulating this type of information. Ideal Skills: - Proficient in VBA for Excel: The ideal freelancer should have a deep understanding of VBA and Excel and be able to leverage this knowledg...
I have a recent backup from 4/1/24 on a hard drive attached to my new computer. My previous computer died, the motherboard went out and somehow my SQL Server data was not saved on the original hard drive. I need to pull the data from a ".DATA" file, or find the missing SQL Server backup files and copy them into my existing program for use. Can anyone help?
I am looking for an expert in MS Excel and navigating a website. We will provide a list of certain colleges and universities in the United States, 258 of them. Go to and type the name of the school, then type “athletics staff directory” and hit enter/search. The first site listed will be the staff directory for the athletic department. Scroll down to the Football staff. For every member of the Football Staff who has an email address listed, you need to enter that staff member’s information (School Name, First Name, Last Name, Title, Email Address, Twitter) into the spreadsheet. This is a single project that would need to be completed each year. Pay would be made upon completion of the project. Mode of communication is English.
Simple job for easy 10 rating. Combine like files into 1 csv. all files have same column heeders NEED JOB DONE ASAP. TODAY USA time.
I need a proficient Excel programmer who can assist with both data analysis and process automation. The project entails: - Data Analysis: Proficiency in sorting, filtering, and performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would invo...Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process automation. - VBA & Macro Skills: Proficiency in VBA programming and creating Macros in Excel is essential. - Template Modification: Experience in modifying existing Excel templates or creating new ones. - Data Integration: Knowledge of integrating and working with local files (CSV, JSON, XML) within Excel wil...
I need a proficient Excel programmer who can assist with both data analysis and process automation. The project entails: - Data Analysis: Proficiency in sorting, filtering, and performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would invo...Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process automation. - VBA & Macro Skills: Proficiency in VBA programming and creating Macros in Excel is essential. - Template Modification: Experience in modifying existing Excel templates or creating new ones. - Data Integration: Knowledge of integrating and working with local files (CSV, JSON, XML) within Excel wil...
I'm in need of an experienced Excel programmer to create a customized program for data analysis. The primary purpose of the program is to assist in data analysis. Thus, it should help in organizing and interpreting large sets of data. The program will need to handle data from two main sources: - Text files (CSV, TXT) - Manual input The ideal freelancer for this job should have a strong background in Excel programming and data analysis, with specific experience in handling various data types and creating efficient, user-friendly Excel programs. Key Skills: - Proficient in Excel programming - Skilled in data analysis - Experience working with text files and manual input - Ability to create user-friendly applications - Understanding of data organization and interpretati...
I'm looking for a professional to help in setting up an SQLite database which will store and manage moderate data with multiple attributes. Key requirements: - The database should be optimized for storing and retrieving moderate data, such as an inventory system with multiple attributes. - No complex data analysis is necessary, just a user-friendly system for managing and retrieving stored data. - Basic search and filter functionalities are required. Ideal skills for the job include: - Proficiency in SQLite database design and management. - Experience in setting up databases for inventory systems or similar systems. - Ability to implement basic search and filter functionalities.
I'm currently experiencing slow performance from my WordPress database that appears to be most apparent when using Mysql/MariamDB which is affecting my admin and dashboard areas. Ideally, I'm seeking assistance from a professional with substantial experience in WordPress and database optimization. The main skills and experience required include: - Knowledge and skills in MySQL/MariaDB - Expertise in WordPress database management - Experience working with websites having more than 20 plugins. Your task will include performing necessary optimizations to significantly enhance the performance of the website, specifically the admin and dashboard areas. Please, include examples of similar projects you've worked on when bidding.
I am in immediate need of a comprehensive database containing information about IT professionals with 2-3 years of experience. This is crucial for a current initiative, thus I need it ASAP. The database should provide: - Name - Phone Number - Skills - Educational Background - Work Experience - Salary Precision is of utmost importance to me. Therefore, an ideal freelancer for this task should have proven experience in data collection and data entry, with a keen eye for detail to ensure the accuracy of the database. Experience in the IT or HR industries would be a significant advantage.
I need to import 70,000 products into my new Amazon store. The project requires someone with a strong understanding of Amazon’s product template, and the ability to work with large datasets in CSV format. There are three main components to this project: - Importing a large number of products: You will need to be able to handle a large volume of data and ensure that it is correctly entered into my Amazon store. - Managing product variations: Each product will need to be listed as a separate entity rather than a variation, so you will need to have a good understanding of Amazon's product listing system. - Updating existing products: You will also need to be able to manage and update existing products in my store. I am looking for a professional who has experience with ...
