개인적으로 교육연구에서 자주하는 (통계)분석 몇 개를 자동으로 할 수 있는 간단한 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 ...
...order! Are you a science journalist or scientist with a great idea still in the beginning stages? Or are you stuck closer to the finish line, unsure what you need to do to get your paper up to commercial or academic publishing standards? I can help! I am a widely published writer of nonfiction, journalism, and science research with a wide variety of publications under my belt. I especially excel in first-person investigative journalism, memoir and biography, mainstreaming science for press releases and articles, and polishing scientific papers pre-publication (especially mechanical engineering, biomedical engineering, Sports science, Ergonomics, Biomechanics). I can advise on a wide variety of styles from mass market to specialist publications and especially enjoy 'punc...
VBA 코드 구현 능력 (Excel Macro를 이용한 프로그램 개발 및 요건정의) 1) 데이터 수집/정리 유형 : 분석 데이터 수집/정리와 관련된 자동화 2) 데이터 분석 유형 : 데이터에 수식/로직 적용 관련된 자동화 3) 데이터 시각화 유형 : 분석 결과를 그래프 표현 관련된 자동화 4) 보고서 작성 유형 : 분석 결과로 요약/결과 보고서 작성 관련된 자동화
...the program will do the rest *The program should upload the videos from a folder in a filepath and use the description from the textfile in that folder. So if you created 2 separate program then I will just load the time delay, file path, the accounts and the proxies. Then it will upload all the video in the 1st folder on that filepath and it will also use the text file in that folder and paste it in the description. Then after that the output will be the URL the accounts profile....
I'm in need of a proficient developer to create a comprehensive computer (in a network) probe software compatible with Windows and Linux. The software should have the following key features: 1. find systems in a network and log details to a CSV file/db table. hostname, ip addresses , mac address etc along with hard disks ,os,version etc. 2. find applications installed in the computers Ideal Skills & Experience: - Prior experience in developing network monitoring and security auditing software. - Proficiency in programming languages suitable for cross-platform development. - Strong understanding of network protocols and security standards. - Experience with compliance monitoring tools and techniques would be an added advantage. Please include re...
I'm seeking an expert in Excel who can help me with a few diverse tasks, such as data entry, creating formulas and functions, and conducting data analysis. The dataset I'll be working with is medium-sized, ranging from 100 to 1000 rows. The primary goal of this project is to organize and structure the data. Ideal skills for this project include: - Proficiency in Excel, including using formulas, functions, and pivot tables. - Excellent attention to detail for accurate data entry. - Experience with data analysis and the ability to draw meaningful insights from the data. - Strong organizational skills to structure the data effectively. Ultimately, I'm looking for someone who can help me streamline my data m...
I'm looking for a skilled Excel professional to help me create a custom inventory dashboard. Key Requirements: - The dashboard should focus on inventory management, specifically, visualizing product stock levels. - The data should be arranged in an intuitive manner that allows for quick and easy inventory tracking. Ideal Skills & Experience: - Strong proficiency in Excel, particularly in creating visually appealing and user-friendly dashboards. - Experience in inventory management, with an understanding of product stock levels and their relevance. - Attention to detail as accuracy in data representation is crucial for this project. - Good communication skills and a proactive attitude to ensure the project's success. Please note that due to the ...
...freelancer who can assist me with enriching the data in a CSV file. This file contains information on over 6000 Fast-Moving Consumer Goods (FMCG) products, including product titles and barcodes. Key Tasks: - Go through the CSV file: Identify each product's title and barcode. - Search for the product image online: Using the product title or barcode, find a suitable image of the product. - Download the image: Save the image to your local system. - Organize the images in folders: Each image should be saved in a folder named after the product category. - Rename the image files: Each image should be renamed to match the product’s barcode with a .png/.jpg/.jpeg extension (e.g., ). Ideal Candidate: - Proficient in data analysis and data enrichme...
...aspects of my project - data analysis and automation. Here's a breakdown of the requirements: - **Data Analysis**: The primary task involves analyzing datasets in CSV format. The selected candidate should be adept with NumPy, able to make sense of the data and derive meaningful insights. - **Automation**: The second crucial aspect is automation. I'm looking to automate certain processes in my project that involve database queries. Proficiency in Django will be necessary here. Ideal candidates for this project would have: - **Strong Python Skills**: You should be well-versed with working on data analysis and automation tasks using Python. - **Experience with NumPy & Django**: Proficiency in these frameworks is a must. - **Data ...
...need of a proficient Excel expert who has a solid understanding of Excel macros and compatibility issues with Excel for Mac 2018 or later. The project involves assessing and modifying an existing Excel macro to ensure that it functions seamlessly on Mac platforms. Key tasks include: - Assessing the existing Excel macro and its functionality - Modifying the macro to be fully compatible with Excel for Mac 2018 or later - Implementing the desired modifications related to data transfer, header and footer creation, as well as digital stamp inclusion The ideal freelancer for this project should have: - Proficiency in Excel macro development and modification - Prior experience with Excel for Mac compatibility issues - Strong unde...
I'm in need of an Excel expert who is well-versed in Excel and has experience in creating detailed and visually appealing dashboards for project management purposes. The primary goal of this dashboard is to help me track the effort and progress of my project. The information that I'd like to track includes: - Time spent on tasks - Percentage of completion - Deliverable status The excel is small and has only 15 rows its more like visualization task so that all data can be projected in one place as a dashboard.
I'm looking for a skilled Excel professional to clean a text-based dataset for me. The dataset is not massive, but it's quite messy. The data cleaning task is relatively straightforward and basic. You'll have to perform operations such as removing duplicates and adjusting formats. Ideal Skills and Experience: - Proficiency in Excel: You should be comfortable working with large datasets in Excel, including applying formulas and functions. - Data Cleaning Expertise: Prior experience in cleaning text data is a major plus. - Attention to Detail: The devil is in the details; I need someone who won't overlook small nuances in the data set. Once the data is cleaned, I'll need you to carry out some basic analysis...
I'm seeking a skilled personal assistant to help with my data tasks, focusing on Excel entry and processing. Key Tasks: - Excel Data Entry: You'll be responsible for entering more than 500 data points. - Data Processing: You will also assist in processing these data entries. Your Skills: - Proficient in Excel: You should be able to work with pivot tables and VLOOKUP functions. - Data Entry Expertise: Demonstrable experience in managing large data quantities is a must. - Organized & Detail-Oriented: The ability to maintain accuracy and precision while handling this large volume of data is crucial. This is a great opportunity for someone who's eager to showcase their Excel skills in a p...
...creation and editing of digital job cards. There is also a requirement for quotes, parts / inventory, archived jobs, and customer management. Both employees and managers will need access to the system, with an admin login section for authorization of completed job cards. We would like the system to export completed jobs to CSV file for automated invoice generation in Quickbooks Online. We will also require the system to import the customer database from Quickbooks in CSV format. Key Functionalities: - Creation and Editing of Jobs - Ability to use system on-site / remotely through the use of iOS or Android web browsing. Some - Ability to select a simple job status from a drop-down combo box eg. In-progress, waiting for collection, waiting on parts, not started, complete...
Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.
Develop macro-enabled Excel file to handle CSV
I'm in need of a professional who can convert a PDF document to Excel format. The PDF contains a mix of text, tables, and images, which must be meticulously replicated in the Excel format. Key requirements: - Handle mixed content: The PDF has a mix of text, tables, and images. You should be able to accurately translate this diverse content into Excel. - Replicate PDF layout: The layout of the PDF needs to be maintained in the Excel format. This means tables should look the same, images should be placed correctly, and the text should be in the same positions. Ideal skills and experience: - Proficient in PDF to Excel conversions: You should have experience in converting PDF documents with mixed content to Excel while maintaining layout integr...
I need assistance in copying text content from my smartphone and pasting it into the appropriate place. Key Requirements: - Copying text from my smartphone- The texts are not in a document but on my phone. A good understanding of how to copy and paste from a phone is essential. - Paste into the appropriate location- The text will need to be pasted into the correct place, whether it be a website, document, or elsewhere. Time Expectation: - I am looking for someone who can assist me part-time. This means the job doesn't need to be completed all at once. A longer-term arrangement is possible if the collaboration is successful. Ideal Skills: - Understanding of basic phone functions - Strong attention to detail - Ability to follow instructions accurately If you are int...
...extraction is for data analysis. The HTML file has multiple tables with some nested elements, not overly complex. Key Requirements: - Need an expert in Python programming - Familiarity with Pandas and Beautiful Soup - Experience in data analysis The job mainly involves reviewing the existing code, fixing any issues that may hinder the data extraction, and ensuring that the extracted table is ready for analysis. Please note that no additional data preprocessing is required, just fixing the current code. --- name "iXBRL" , inside folder contain multiple html file(hundreds to thousands), each html file contain multiple tables(vary from 15-35, depend on each html file). Python to extract specific table and vertically stack them together to create ...
Ho bisogno di un programma che mi permetta di aggiornare disponibilità e prezzo di vendita dei prodotti presenti nello store shopify partendo da un file excel/csv che viene generato automaticamente ogni x ore e viene esportato dal getionale su cartella FTP
I have a project that requires purely text data entry. I have a set of handwritten notes which need to be entered into a spreadsheet. Key Requirements: - The data is text-based, and it's crucial that the freelancer can transcribe this accurately and efficiently. - Proficiency in using spreadsheet software like Excel or Google Sheets is a must. Ideal Skills: - Fast and accurate typing skills - Proficient in using spreadsheet software - Experience with data entry, especially from handwritten sources
We're seeking a detail-oriented and web-savvy freelancer/contract...resources, including: o Search engines (Google, Bing, etc.) o Social media platforms (Facebook, Instagram, LinkedIn) o Industry directories and publications (list specific resources if known) o Business databases (mention specific databases if known) • Gather and verify contact information (name, email, phone number) for each lead. • Compile lead data into a Excel format . Qualifications: • French reading and understanding - ONLY • Excellent research and data collection skills. • Proficiency in using online search tools and social media platforms. • Strong attention to detail and accuracy. • Ability to work independently and manage time effectively. • Famil...
I need an Excel tool that can sort data by category and provide users with an interactive experience. I'm looking for an experienced Excel developer who can create a user-friendly, yet advanced, Excel tool. The tool should have the following features: - **Filtering**: The tool should allow users to filter data by category. This is a crucial aspect of the tool's functionality, as the data will be organized by this field. - **Interactive Buttons**: I would like the tool to have buttons that allow users to sort data. When a button is clicked, the data should rearrange itself based on the selected category. For example, when a user clicks on the button related to 'Category A', all data entries related to ...
From 2.5 lakh records, need to find the duplicate data and make different sheets with unique data. Example: In a sheet of alphabets, that have multiple A’s, B’s, C’s. Now I need separate them and make a sheet with all A’s, separate sheet with all B’s, another sheet with all C’s.
I'm in need of a skilled individual who can assist me in creating flat file templates for Amazon. I need a highly experienced Amazon listing expert. I need it in 24 hours. I will also work with you there are 1125 products. And Raw file is ready upc, description, Sku etc. It is copy paste work. - The task will involve exclusively the creation of the templates, not data importing or formatting. - Please specify your experience with Amazon's flat file system when responding. Ideal skills: - Proficient in creating flat file templates for Amazon - Prior experience with Amazon's flat file system - Excellent attention to detail
I'm in need of a skilled individual who can assist me in creating flat file templates for Amazon. I need a highly experienced Amazon listing expert. I need it in 24 hours. I will also work with you there are 1125 products. And Raw file is ready upc, description, Sku etc. It is copy paste work. - The task will involve exclusively the creation of the templates, not data importing or formatting. - Please specify your experience with Amazon's flat file system when responding. Ideal skills: - Proficient in creating flat file templates for Amazon - Prior experience with Amazon's flat file system - Excellent attention to detail
I'm looking for a professional who can help with Excel work, primarily focusing on formula creation and formatting tables. Key Requirements: - I need assistance in creating formulas that can automate calculations and processes in Excel. - I'm looking for a clean and simple format for my tables, in line with a minimalist style. Ideal Freelancer: - Proficient in Excel, with a deep understanding of formula creation. - Experienced in table formatting and design, with a flair for minimalism. - Able to deliver high-quality, error-free work in a timely manner.
I am looking for a programmer with previous experience in building a Group Buy SEO Panel with the following tools, with the possibility of adding tools later. semrush freepik envato elements Motion Array pacdora with ...envato elements Motion Array pacdora with the following download limits: freepik 25 files /day envato elements 30/day Motion Array 30 /day pacdora 30/day I do not want a page specifically for payments, but in return I want a section at admin dashboard to generate activation keys for each service. I will sell these keys, and once the customer obtains an activation key for a service, he will paste it in a specific place on user dashboard and click on the word Activate, and the service associated with this key will be activated. Please send a previous project y...
...understanding of the importance of a well-designed website and the value it brings to a business. • Tech Savvy: Familiarity with basic website design concepts and digital marketing trends is a plus. Technical Requirement: • Fast Internet • American English Accent • Quality Microphone Ready to take your sales career to the next level? We are! How to Apply? (Do the Following to be considered, copy and paste the template below and use as your cover letter) 1. Record Your Voice: Read the following sales script with your voice: 2. Speed Test Goto: Change server to any Los Angeles, CA Server. Screenshot or link me to your test
...detailed financial reports and dashboards, primarily based on data from Excel spreadsheets. Key Responsibilities: - Develop compelling, visually appealing reports and dashboards that are easy to interpret and navigate. - Tailor the reports and dashboards specifically to financial analysis, ensuring they provide the insights necessary for informed decision-making. Ideal Candidate: - Proven experience creating financial analysis reports and dashboards in Power BI. - Proficiency in integrating data from Excel spreadsheets. - Strong attention to detail and the ability to translate complex financial information into clear, concise visual elements. This project requires a high level of expertise in Power BI, financial analysis, and data visualization. ...
I have 20 pages that need some content generated from ChatGPT and entering on to the page. This includes a short bit of text (150 words) for the main content and YOAST meta descriptions. I'll provide full instructions and the correct prompts to use with ChatGPT. This is a super simple copy and paste job and should only take a couple minutes per page. Please be familiar with WordPress and ChatGPT so you can get this done quickly. Also you will need to update the DNS in your local hosts file to be able to access the site (I can show how) This is 1hrs work at most so please bid accordingly.
I have a substantial amount of data that needs to be copied and pasted, and I'm looking for a specialist to take over this task. The details of the specific tasks, files, and source content are still to be defined, however, the job will involve copy-pasting from a variety of sources.
...handle this time-sensitive project myself. Again, to be clear, if you are not available right now to work on this project for the next couple of hours, please do not bid. This site is a development environment and we are working on a new version of the site. The products are already created in WooCommerce. What I need is for you to go to the existing production website and copy and paste all of the product data so that the product descriptions, weights, sizes, prices, and dimensions are correct. The images are already added with our custom color swatch plugin. Here are the two sites so you can review the product info that needs to be copied over: - Production - Development Here is a list of the products in their various sizes:
I'm seeking a seasoned back-end engineer with expertise in Node.js and MongoDB. Your primary responsibility will be developing APIs that integrate seamlessly with external services. Key tasks include: - API development: You should have a proven track record of creating robust, efficient APIs. - Integrating with third-party services: The APIs ...scalability is crucial, even if it is not explicitly stated as such by the client. Ideal skills and experience for this job include: - Proven track record of API development in Node.js - Strong understanding of MongoDB - Experience in integrating various third-party services - Prior work on projects with high performance and scalability requirements If you believe you have the necessary skills to excel in this role, I encourage you t...
We are seeking experienced lead generation professionals to assist in identifying companies raising equity capital for a growing company over the next 3-6 months. Ideal candidates will have a strong background in...400 emails per week to well-researched leads in specific industries. 2. Retainer: £1000 per month. PROCESS 1. Lead Research: Identify and research potential leads. 2. Email Outreach: Send emails to prospects. 3. Response Handling: Forward prospect responses to the business developer. 4. Scheduling: The business developer will schedule and conduct the sales calls. 5. Data Management: Upload researched data to our CRM in Excel format to ensure no duplications. If you are a driven lead generation professional with the required experience and skills, we...
Data Entry Required Your job is simple copy and paste. All the data will be given to copy from. We are looking for genuine and honest people. Ideal skills: - Attention to detail - Proficiency in data entry - Strong work ethic - Honesty and reliability Project Duration: Ongoing Payment: $5 per work Payment frequency: daily basis Contact us for more details.
I'm in search of a versatile freelancer with skills in Word, Excel, programming, and graphic design. Your expertise in these areas will help me in different domains. Your main tasks will include: - Formatting documents in Word, ensuring a professional and consistent layout. - Creating Excel spreadsheets and conducting data analysis. Proficiency in Excel will be crucial to help me interpret and visualize data effectively. - Developing software or web applications. I am working with Java/Spring/JavaFX and am open to creative development ideas and solutions. - Designing logos and visuals. Your ability to create engaging and unique visuals will be a big asset to my projects. I am currently using Word 2010 and will be working with Java/Spring/JavaFX fo...
I require an expert script writer who can create a bash script for data processing tasks that involve the creation and deletion of files, specifically CSV files. Details: - The main task will involve managing CSV data. - The bash script should be able to create and delete selected CSV files. - I'm looking for someone skilled in bash scripting, especially with a focus on file handling and data processing. - Previous experience in working with CSV files, data manipulation and command line tools will be required. - We need the script to be concise, efficient and capable of running smoothly without unnecessary delays. Looking forward to your interactive and engaging responses.
...few hours please do not bid. I will just do the work myself if no one is available as it can not wait. The project is reformatting static content from an old WordPress site to a new WordPress site and a new theme. The current site uses the Divi theme, and it is broken, for lack of a better term. We are not trying to unravel the mess from the previous developer; we are just going to copy and paste the content from the old static pages and reformat it on the new site. The new site is also WordPress, using the Shoptimizer theme and the Elementor builder. The new theme is already installed with a base configuration that includes the footer/widgets and header/navigation, so the only content that needs to be moved is the body of each page. There are a total of 8 static pages. htt...
I have a list of 50000 urls, I would like to scape the pages to see if they contain references to scripts - I will provide a list of the urls and the scripts. Deliverable should be an excel with the 50000 urls and whether they contain the link for each script. Looking for fast turnaround
Title: Automated Data Retrieval from Websites Using CRM and CID Numbers Description: We are looking for an experienced developer to automate the process of retrieving data from specific websites using CRM and CID numbers. The goal is to develop a script or tool that will: Look up Doctor's Specialization: Use CRM numbers to search on the website: CFM Doctors Search Extract doctor's information including their specialization. Look up Disease Descriptions: Use CID numbers to search on the website: MedicinaNet CID10 Search Extract the disease description. Deliverables: ( ) A script or tool that can take a list of CRM and CID numbers as input. Automate the search process on the specified websites. Extract
I'm looking for a skilled professional who can migrate an existing voicemail manager system from Google Script (Javascript) to Office365. The primary purpose of this migration is to rebuild the system on a completely different platform. Key Requirements: - Proficient in Google Script (Javascript) - Familia...intricacies of voicemail manager systems. The project's success will depend on the freelancer's ability to effectively transfer the existing system's functionalities to the new platform. The system must be rebuilt using Javascript, ensuring compatibility with the desired platform: Office365. I also need help to complete previous project. Help with the following: 1. Batch file to merge Ruckus csv files instead of overwriting. 2. Batch file to find missi...
...Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 300 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge of VBAs, Macro, MS Office skills to drive automation o...
Hello, I need convert a PDF invoice to Excel to import to our invoices software
I'm looking for an experienced Power BI developer to create bespoke reports and dashboards, which will be integrated into Microsoft Teams. Tasks: - Handling data from Excel spreadsheets and converting it into insightful reports and dashboards. Skills and Experience: - Strong command of Power BI for report and dashboard creation. - Proven experience with Excel spreadsheets. - Good knowledge of integrating Power BI into Microsoft Teams. The goal is to make complex data easy to understand, facilitating better decision-making within our team. Your work will directly impact our day-to-day operations and strategies.
I have a Python notebook containing well-structured code that effectively translates a sample of a large dataset from English to Arabic. However, the current code cannot handle the entire dataset due to its size. using : model_name = 'Helsinki-NLP/opus-mt-en-ar' Tasks: - Modify the ...effectively translates a sample of a large dataset from English to Arabic. However, the current code cannot handle the entire dataset due to its size. using : model_name = 'Helsinki-NLP/opus-mt-en-ar' Tasks: - Modify the existing Python code in the provided notebook to translate the entire dataset from English to Arabic. - Ensure the translated data is saved in two formats: Comma-Separated Values (CSV), and Apache Parquet (.parquet) - Provide the CSV and parquet fi...
...a specialized WordPress developer with experience in Excel operations and data showcasing. Key tasks: - Create a WordPress page that extracts numeric and text data from an Excel sheet. - Implement highlights and color-coded information on the webpage for better readability and understanding. - The data on the Excel sheet will be updated on a monthly basis, hence the website should be able to fetch the data automatically upon any modifications. Ideal skills: - Proficiency in WordPress and Excel integration - Experience in creating visually appealing data showcases or infographics - Strong understanding of data extraction and display technologies The aim is to have a user-friendly webpage that accurately repres...
I'm in search of an Excel expert who can assist me with complex tasks in Excel. Specifically, help is needed in two key areas: - Formulas & Functions: While basic arithmetic operations are simple for me, I need assistance with text and date functions. - VBA Macros: I'm looking for someone who can develop advanced user forms and interfaces. This requires a high level of VBA expertise. The ideal candidate would have a strong background in Excel, with a focus on formulas, functions, and VBA. Previous experience working on advanced macros and a deep understanding of text and date functions will be a huge plus. The ability to communicate effectively and understand my specific needs is essential.
reproduire le même a l'identique copier coller avec les calcule automatique les formule de la ou il ya tout les chiffre
I'm in search of a versatile freelancer with skills in Word, Excel, programming, and graphic design. Your expertise in these areas will help me in different domains. Your main tasks will include: - Formatting documents in Word, ensuring a professional and consistent layout. - Creating Excel spreadsheets and conducting data analysis. Proficiency in Excel will be crucial to help me interpret and visualize data effectively. - Developing software or web applications. I am working with Java/Spring/JavaFX and am open to creative development ideas and solutions. - Designing logos and visuals. Your ability to create engaging and unique visuals will be a big asset to my projects. I am currently using Word 2010 and will be working with Java/Spring/JavaFX fo...
