Xls csv tabPekerjaan
I've uploaded some basic data. It has 2 columns. Column 1 is a Publication Index and column 2 is an authors name. I need a T-SQL query that will create a pivot table that will put the authors names into columns and the PMID's into rows. The xls sheet has the data and the output that I need. I'm posting the question here because I need a faster answer than posting on StackOverFlow. The data will have over 8,000 rows of data and the columns or names will be over 100. My current T-SQL is SELECT TOP (100) PERCENT PMID, AuthoringName FROM dbo.[] GROUP BY PMID, AuthoringName ORDER BY PMID, AuthoringName I'm using MS SQL 2019
I am looking for a web scraping expert to help me collec...scraping expert to help me collect Instagram followers data. Specifics: - I need to scrape data from one specific website, namely Instagram. - The data I require is text content only, such as usernames and follower counts. - The collected data should be parsed and organized in a CSV file format. Ideal Skills and Experience: - Proficiency in web scraping techniques and tools. - Experience with scraping data from social media platforms, particularly Instagram. - Strong knowledge of parsing and organizing data in CSV format. Please provide examples of previous web scraping projects you have completed, particularly those involving Instagram data. The Final Output type should be in below attached format (Shop_Type Col...
If you are a Lucknow based Android Developer / Company please Send your proposal for the Android Development And Report pdf generation project A CFR 21 COMPLIANT PDF REPORT WILL BE NEEDED TO GE BENERATED INAPP . PDF TEMPLATE WILL BE PROVIDED API TO GET THE DATA WILL BE PROVIDED YOU are required to code the module and deliver working zero bu...COMPLIANT PDF REPORT WILL BE NEEDED TO GE BENERATED INAPP . PDF TEMPLATE WILL BE PROVIDED API TO GET THE DATA WILL BE PROVIDED YOU are required to code the module and deliver working zero bug app. Must not crash when date beyong 365 days are used by the user as input and partition data to effectively get the resources from the server . Pdf will use graphs tables and export format will be text and CSV . Time zone will be required to b...
I'm seeking an expert familiar with converting NETcdf files into CSV format. This is a one-time conversion task. Firstly to show me that you read this, please write the word "readspec" as the first word of your reply. I have attached a small file which you need to convert to be eligible. There are about 5000 files in total in this project and I need you to bid to convert all 5000. I have attached the smallest file (2000 kb) and the largest file is (4600kb) to give you an idea of size.
I am looking for a freelancer who can help me implement an HTML form to CSV functionality for creating a survey. The ideal candidate should have experience in HTML and CSV file handling. Specific requirements: - The HTML form should be designed to collect moderate data, including multiple choice answers and ratings. - I already have a list of specific data fields that need to be included in the CSV file. Skills and experience required: - Proficiency in HTML and CSS for designing the form. - Strong knowledge of CSV file handling and data manipulation. - Familiarity with handling moderate data types such as multiple choice answers and ratings. If you have the skills and experience mentioned above, please submit your proposal with relevant examples of your previ...
Hello, I would like to modify my website to make it resemble this website with our colors I would like to add a tab for online ordering, a tab for our history, and also a Food Truck tab. Thank you.
The price tab has gone missing and we just need someone to help us get it back.
I'm in ne...imported products are ready for sale. Key tasks include: - Importing products from our catalog to Shopify - Translating product descriptions into Latvian and Russian - Setting up the store for the products to be ready for sale The ideal candidate is someone who: - Has extensive experience with Shopify and product import - Is fluent in English, Latvian and Russian - Has a working knowledge of CSV files - Is detail-oriented and can follow instructions accurately - Has a knack for writing engaging product descriptions would be a bonus Please note that our product catalog contains product descriptions in English, which will need to be translated to Latvian and Russian through the course of this project. Does this sound like a job you can excel in? Place your bid ...
...comment/uncomment the relevant code to switch from sample to real data * You must implement all compulsory fields on `UsageSummary` (totals and averages for varying time horizons) *Calculate the optional field `UsagePeak`. [What is peak demand]() can help you understand the underlying concept there Other tips * Add tests * Information on the CSV file format can be found at [](). Short version: ignore the first 3 columns, column 4 is the date, and columns 6+ are the kwH used in each half hour window. * Keep an eye out for the nominated units on data fields. [kW !== kWh](
...and utilizing OCR to extract text. OCR with Google Cloud Vision API: Integrate Google Cloud Vision API to perform OCR on uploaded images. Extracted text data should be accurate and neatly formatted for further use. Spreadsheet Management: Compile the generated URLs and OCR-extracted text into a structured spreadsheet format. Consider using Google Sheets API for this purpose, or generate CSV files as required. Security and Compliance: Implement robust security measures, including secure handling of API keys and sensitive data. Ensure compliance with relevant data protection laws and privacy standards. User Authentication and Access Control: If a web interface is developed, include user authentication mechanisms. Set appropriate access controls for both the web ...
Hello, Thanks for your interest in the project. This project is to web scrap Linkedin profiles. We are looking for data sets to enable edtech companies to be able to get them leads. Our AI model connects - Student and "Open to work" profiles on Linkedin to various Edtech products. Linkedin cu...diverse range of datas like text, images, and product details would be greatly appreciated. The scraped data needs to be in a Excel format for ease of use. Your understanding and experience regarding data format will be crucial in this role. Ideal skills: - Proven experience with web scraping - Proficient in handling diverse data types. - Strong understanding of data formats, specifically CSV. The money will be transferred ONLY AFTER the entire data set is transferred. Lo...
For this endeavor, I am in need of a capable web developer well-versed in HTML, CSS, and React.js. The thrust of t...the dynamic form are listed below: - Input fields - Dropdown menus - Radio buttons - Toggle buttons for hidden or advanced options - Submit button Upon click of the submit button, the JSON that will be dispatched to the backend needs to be displayed. Something crucial to this project is the specification that data from tabs not selected by the user should not be sent. Only data from the selected tab is to be forwarded to the backend. Ideal candidates for this role should possess strong proficiencies in HTML, CSS, and React.js, as well as a firm understanding of JSON and UI schemas. Prior experience with dynamic form creation and frontend/backend data exchange is re...
Add tab/page/menu item for PLUMBERS NEEDED Content to be provided. New page needs to have a simple fillable job application form
I am seeking expertise in creating a project that involves reading and recording CSV text files on a MicroSD card using a standard SPI module. The code should operate without using FreeRTOS system. Moreover, the developed code will need to be compatible with Keil 5, and all project files should be shared in addition to the project folder. Tasks to be Accomplished: Implement a module for writing and reading text data in CSV format on a MicroSD card. Ensure seamless integration with a hardware SPI controller. Deliver complete project folder to work with Keil 5. A hands-on experience with MicroSD operations, solid understanding of CSV file manipulation and a strong knowledge of SPI hardware controller is expected for this task. Familiarity with Keil software would ...
I would like a CSV / excel file of a list of up to 250 Champagne companies and their emails. Rather than a generic company email, it would be ideal to have an email of a contact at the company, for example, the CEO or Head of Marketing. Ideally a three column sheet with name of company, name of contact (ex: Head of Marketing), and company contact email.
put into .csv...website to scrape info from (), need this done now. tell me how long it will take to be delivered in your quote. tell me accurate price
I'm looking for a Python program with which I can delete my many email accounts, the inbox and then also the deleted folder. There are several 100 accounts, login then inbox check and delete, then empty the deleted folder. account come in CSV format Login;pass;imap,smpt;port
1. Generate Dublin(or dynamic given location) routes used by passengers using min 2 public transport hops(best route). For example :- using 2 bus stops, 2 Luas stop, Dart Stop or combination of all these. Example :- Source A -> B -> C -> D. A=Starting Point, D= Final Destination. Need to find best route :- A -> B -> C -> D. Best route should have m...locations where people walk more than 10 mins to reach workplace using public transport(bus/train/tram etc) since 1 year within Dublin(or dynamic given location) - Generate which Dublin(or dynamic given location) routes are max distance travelled by pedestrians(no public transport) on foot since 1 year. ** All reports should have query string over googlemaps or weblink to generate report in csv/xls format wi...
...and the requirements of the RAG protocol. Creating a Robust Database System: Transition from using CSV files to a more advanced database system to store and manage various elements such as scraped content, written articles, outlines, and keywords. This database will play a crucial role in linking content to initial prompts and managing the workflow. Frontend Development in React.js: Develop one or two screens using React.js for users to modify prompts and code. This feature will enhance user interaction and make the system user-friendly. Building a Simple UI for Automation: Design a UI that facilitates automation of the entire application. This UI should include: An upload feature for CSV files for easy data input. A function to automate the selection of the first 10 re...
I am looking for an expert in MS Excel to develop a special .csv file generator as per the attached BRD and .xlsx spreadsheet prototype. This tool will allow us to maintain static content in various locales inside our Magento 2 CMS. Skills and experience required: - Expert in MS Access VBA and Macro. - Advanced knowledge on the coding functions. - Ability to challenge or question the BRD in a constructive manner - Potentially propose functional amendment/solutions which serve the ultimate goal. - Ability to work with provided designs or suggest design recommendations - Strong communication skills to discuss additional features. - Ability to align with project lead and other developpers under the project. - Access to Trello Dashboard and MS TEAMS for collaboration purposes. The fo...
In need of an experienced WordPress professional to handle the task of uploading and programming a new version of a CSV suburb postcode file on my site. The current file is outdated and the version is undefined. Here are some of the tasks involved: - Correct identification of the current version of the outsated file - Upload and programming of the new CSV suburb postcode file Your application should primarily detail your experience with WordPress and especially tasks of similar nature. - Upon completion, I'd prefer the updated suburb postcode file to be submitted via an online file sharing platform. If you have stellar WordPress experience and can handle this project with precision and efficiency, I'd love to hear from you.
I have a Python script that scrapes data from Zoominfo. I am looking for someone who can fix this script. The script is working fine but it's creating pkl file and not saving the data to CSV file. I will provide full information and the script to the awarded freelancer. Looking for someone who can start immediately and finish it asap.
I am seeking an experienced C# and .NET developer capable of designing a minimalist and clean XAML interface. The primary functionality required for this project revolves around graphic user interface design, hence strong skills in this area are vital.I need help in a particular area of code where I am feeding a CSV files and need to have calculation for a particular filter of elements. A few defining aspects of the role: • Proficiency in working with C#, .NET framework and XAML files.
I am seeking a savvy programmer who can help with integrating my Amazon orders into QuickBooks. Experience working with CSV file manipulation and automated importing processes will be required for this project. Key deliverables: - Generate a solution to import Amazon order data, consistently updated on a weekly basis. - Ensure imported Amazon order data is batched together as opposed to individual transactions. Project Requirements: - Proficiency in QuickBooks integrations - Experience handling CSV data files - Familiarity with Amazon seller platform - Organized approach to batching multiple records together This project paves the way for smoother, more streamlined business processes. Please create a trial Quickbooks account and share username and password showing you...
I am in need of an expert who can create a customized Chart of Account (CoA) CSV file compatible with Xero software. The CSV file needs to be tailored for a charity organization. Key tasks involve: - Understanding the specific structure of our charity organization - Customization of CoA based on our specific business requirements - Ensuring the created file seamlessly integrates with Xero Ideal Skills: - Deep understanding of Xero software - Strong knowledge in CoA accounting principle - Experience with charity organizations is preferred - Skilled in CSV file creation Please take the attached file from the ACNC and make it for xero chart of accounts.
I am seeking a Visual Basic Specialist to modify a script that I use daily at my job. The script has been effective for many months, but due to a recent update in our company's software, it is no longer functional. The script's purpose is to translate a single txt page and extract the necessary data needed to generate a CSV file containing only the required information. This is a small project, requiring script adjustments rather than building from scratch. If interested, please send me a PM, and I will share example files with you – an old one pre-update that still works and a new file post-update that doesn't work. Additionally, I will provide some instructions.
...translation - Need only "DROPSHIPPING" products - Need products selling 1 unit at a time - fixed size for video's for all products - Description heading - titles in thick bold - image watermark remover in bulk - i need products scraped from website, before adding on to CSV i would like the script to price match on ,if the product is cheaper than , it needs to be listed on the CSV file, if product script data price is more expensive product needs to be skipped (so its not listed on the CSV file) and also need to combine all the product data with importify app or something similar to full fill orders =========================================================== websites should be compatable with Etsy Gearbest
I am looking for a freelancer to create a WordPress search box for my website. Here are the details of the project: like this: Wordpress or woocommerce - A drop-down list box with the option to type the name of a country - The country names with a flag will appear in the list After sele...or woocommerce - A drop-down list box with the option to type the name of a country - The country names with a flag will appear in the list After selecting a country, a page with the name of the country will open For example, if I chose USA, it will open a page Similar content will appear on all pages, and only different prices, so I also need the option to upload prices from CSV and I won't have to update each page of each country separately
I'm looking for a skilled specialist who may expand the functionality of my Opencart Import Inventory Tool by adding a new feature. It should now be capable of handling a different type of CSV, specifically a Quantity and Stock CSV. Key Tasks: - Enable import of Quantity and Stock CSV files to the system - Ensure correct mapping to Product ID and quantity fields The ideal freelance candidate is expected to have: - Advanced knowledge of Opencart - Proven experience with CSV file manipulation - Clear understanding of inventory management systems This project is all about enhancing my tool's capacity to manage inventory effectively by updating product information, thus giving a competitive advantage to our e-commerce business. Your contribution will b...
I need assistance with totaling up mileage from my 4 CSV files for tax purposes. These files pertain to the year 2022, specifically the distance traveled and associated expenses. _Your Responsibilities:_ * I would like this calculation to be done through Google Sheets. * I need totals of fuel usage and mileage, this is not a day by day report but a simple tabular summary. The ideal candidate should have excellent Google Sheets skills, experience with data analysis, and the ability to interpret financial data from CSV files. Knowledge of taxation, particularly as it pertains to travel expenses, will also be beneficial.
I need expertise in file conversion from xlsx to csv format, specifically for shipping carrier data. This project involves manipulating columns and data transition to properly fit a specific csv structure. Key Responsibilities: - Convert xlsx file provided into Comma-separated values (CSV). - Ensure the data preset from the csv template is being used. Attached you can find screenshot and example of the csv!
...looking for a freelancer who has the expertise to assign ratings (1-10) to individual schools in the UK based on their performance - such as exam results, student progress, inspection ratings, etc. It will include schools in England, Scotland & Wales: England – Primary & Secondary Scotland – Primary & Secondary Wales – Secondary We have all the data in xls, a sample of which is attached. We also have notes on which data within the XLS to use for the ratings as well as suggested weights, etc. We will require ratings for different themes such as test results, progress, pupil destinations, inspections, etc, and an overall summary rating for the schools. Please see the link below for some methodology approaches used by the leading supplier o...
Hi, We have a Projects section (sort of like Freelance) in our App (I can't share the code, but I can work with you live via Screenshare real quick). We need to add 2 buttons. 1. View All Proposals (the API already exists AND the proposals actually show partially in a tab that's already on the page). Maybe with a way to click on an item to see the full proposal text or expand it down. Plus, I need an "Accept" button for each Proposal Item. I already have a function for accept and can quickly write an API endpoint for the Accept functionality (that posts the project id and user id). 2. Submit Proposal - we have a submit proposal feature but it's a popup/dialog and only allows you to put Amount and Description. I need to add a Dropdown for Estimated Timeli...
Based on the text tables and , build a report in an analytics system (Tableau or Data Studio), containing charts that will display the cumulative dynamics of the following indicators on certain days: - % of paying users - ARPU (Average Revenue Per User) - ARPPU (Average Revenue Per Paying User) - Revenue (total purchase amount)...purchase amount) Where the X-axis is the number of days since the player's registration, taking the following values: 3, 7, 14, 28 days (an example of the chart is provided below). Note that if the value for the subsequent day is lower than the previous one, this indicates that the task is done incorrectly (the value accumulates over time and therefore cannot be lower than the previous day). Ill send csv to those who can do the task in 4 hours
I am looking for a skilled web developer to create a global payroll website for my new enterprise. The website needs to be compatible with phone, tablet, and desktop devices. I specifically require the following functionalities: - Employee Self-Service Portal: The website should have a portal where employees can access their payroll information, such as pay stubs, tax forms, and benefits. In terms of design and layout, I have a specific design in mind. Therefore, I am looking for a developer who can bring my vision to life. The ideal candidate should have experience with Drupal or Webflow, as these are the only platforms I want to use (no WordPress). If you have the necessary skills and experience to create a responsive and user-friendly global payroll website, please reach out to me.
I am in need of a CSV product file incorporating a thousand appliances and electronics for WordPress website. Here are my specific requirements: - The CSV file should contain comprehensive information including the name, description, and price for each of the products. - Inclusion of images for each of the products is also critical for this project ensuring accurate representation. - The CSV file should also be suitable for WooCommerce and can be inserted into Google's Merchant Center. Ideal expertise and skills required for this project include: - Proficiency in creating and managing CSV files. - In-depth knowledge of WordPress, WooCommerce, and Google Merchant Center. - Experience with electronic and appliances related data. - Understanding the importa...
...The main goal of the project is to populate a web form with data from a CSV file. Source of the CSV file: - The CSV file will be a local file, stored on my computer. - Sample CSV attached. CSV has 19 fields, Webform has 19 fields. Requirements of the web form: - The web form requires both text fields and selection boxes to be filled in with the data from the CSV file. - - You can view the form here: Reporting and logging: - I would like a simple log of the form submission results but this requirement is not a must have, only a nice to have. Ideal skills and experience: - Strong proficiency in Selenium automation - Experience with working with CSV files - Familiarity with web forms and different input types - Attention
I am in need of a professional developer to custom build a screen for my Time & Attendance system. The following features must be included on this screen: The custom screen is a job timesheet which will be added as an menu item on the "Attendance" tab right under "Timesheet" and say "Job Timesheet" which list all the attendance for a job, exactly like the timesheet but for multiple employees on the same job. It will be interactive, like the original timesheet, so one is able to click into a time of an employee which will takes one to the punch to carry out an arbitration if need be, just like in the original timesheet. On the "Jump Too" button an option is added to jump to the selected employees timesheet. Below the clockins there is...
I am currently facing an issue with my Excel spreadsheet. The macros have suddenly stopped working, and on one particular tab, the entire workbook shuts down when I perform any action. This issue occurs even with basic actions like entering data, copying and pasting, or formatting. This is occurring despite the fact that no recent changes have been made to the macros or the spreadsheet layout. Troublingly, there isn't an error message to identify the problem, the workbook just shuts down. Ideal Skills & Experience: - Expertise in Microsoft Excel - Experience with Excel Macros - Strong troubleshooting ability - Ability to work independently and diagnose the root cause. Please note that the freelancer will need to uncover the issue and provide a solution to prevent this fro...
I am looking for a talented graphic designer to create a new logo for my brand, "Laelia Wellness" I want two versions: (a) a full logo with the full name, possibly with "Wellness" subordinated to "Laelia" and (b) a small logo that fits nicely as a web browser tab icon (eg, Google Chrome) and as a profile picture icon (eg, Gmail). The small logo can either be an entirely separate logo from the big logo (ie, a standalone separate design) or it can be the "L" in "Laelia Wellness". I am indifferent on this point and am open to creativity. The color scheme should be some shade of red (I am open to any kind of shade) and potentially a blended color (ie, from darker to lighter red, like the Canva logo goes from darker to lighter blue). I...
...-------- Make a spreadsheet that contains five columns (Artist, Date, Time, Venue, Link) and approximately 120 rows. Please ensure you use proper Title Case, UPPERCASE will be rejected! Time should be AM/PM format. Link should be performers Facebook if available. If not, choose website. If no website, your choice of available links (if any). Please make spreadsheet with Google Sheets or a plain CSV. --• Data for February 16th: --• Data for February 17th: --• Google Sheet Example (view only): --------------------------------------|| 1200x630px IMAGES ||-------------------------------------- FIGMA is highly encouraged!! I need 88 quick and easy (copy
I am looking for a freelancer who can help me with a data encoding project. Here are the details: Type of Data: The data that needs to be encoded is in text format. Desired Format: I would like the encoded data to be in CSV format. Data Volume: There are approximately 100-500 entries that need to be encoded. Skills and Experience: - Proficiency in data encoding techniques - Experience working with text data - Familiarity with CSV format and its specifications - Attention to detail to ensure accurate encoding - Ability to handle a moderate volume of data If you have the skills and experience required for this project, please submit your proposal.
I am looking for a freelancer to create a list of co-op grocery stores in the Western Provinces of Canada. The specific information I need for each store is the contact information. - Coop Name, Store name, Address, Admin Email. in CSV format Skills and Experience: - Strong research skills to gather accurate contact information for each store - Familiarity with Canadian provinces and their respective cities - Attention to detail to ensure all necessary information is included for each store Information would be collected from - I would be looking for the emails specifically which are not hard to find - a video guide would be provided and should be followed. If you have a way to scrape the map page it could also be an option and then manually collect the
I am looking for a skilled developer to make functionality improvements to my Opencart website and add new stockists using a CSV file. Specific alterations needed: - Implementing functionality improvements to enhance the overall user experience and site performance Platform: - The website is currently built on Opencart New stockists: - I need to add multiple new stockists to the website using a CSV file Ideal skills and experience: - Proficiency in Opencart and experience with making functionality improvements - Familiarity with importing data from a CSV file and integrating it into an e-commerce platform
I want a developer who is VERY familiar with the Central Bank of Russia API to generate a lists of 15 URL's for the following datsets listed on the four web pages below. I am storing them as time series so I need to be able to parse the result to get a time series. THIS IS CRITICAL. It MUST be JSON, XML, CSV or TSV. The URL's must be single line that a browser can accept. An example of a url (US$ FX rate) is: 1). RUONIA Index and Averages Web Page: I need FOUR single line URL to return the historical data in XML/JSON for the date + 4 columns Index 1-month RUONIA Average 3-month RUONIA Average 6-month RUONIA Average
Se tienen 8 informes en PowerBi desktop los cuales se requiere se exporten cada uno con un nombre específico a un formato .CSV en una carpeta especifica cada uno con un nombre específico. Esto debera porgramarse para que se genere una vez al día.
Looking for an Excel expert to assist with my spreadsheet on a Windows operating system. I require the spreadsheet to be converted to a CSV while retaining all data structures. In addition, there are several calculations such as addition and multiplication needed. The project will also involve: - Displaying the calculated results in a new Excel file, is separate colums to enable the excel spreadhsheet to imported into another database. Ideal candidates should have: - Proficiency in a variety of Microsoft Excel formats and CSV files - Experience with Windows OS - Aptitude for accurate data entry and calculations A file is attached to show the format the data is in. The actual files that need converting are extremely large and have many thousands of records.
I'm seeking a skilled freelancer who can scrape 'Table data' from websites. Critical skills necessary for this project include web scraping and programming. Once collected, the data should be formatted accordingly to be integrated into an API. Although the preferred format was not specified, knowledge in JSON, CSV, and XML is desirable. I need this project completed promptly, meaning time management and commitment will be vital.
