Columnscông việc

I am creating an xls file for an initial database load. I have several source xls files that need to be transferred into a primary xls based on the correct columns. I will provide the source files with the correct data to transpose. More details can be given once the job is accepted.

I am looking for a Python developer who can help me extract HTML table data into an Excel (xlsx) file. Specific requirements for the project include: - I have a specific website or HTML page in mind from which I need to extract the table data. - The complexity of the table data is simple, with few columns and no nested tables. - I need the Python script to be reusable for future data extraction tasks, as I plan to use it for similar tasks in the future. Ideal skills and experience for the job: - Proficiency in Python 3.9. - Experience with web scraping and extracting data from HTML tables. - Knowledge of working with Excel files (xlsx) using Python libraries. - Strong attention to detail and ability to handle different data types. If you have the necessary skills and experienc...

... It allows you to obtain rich administrative data linked to a specific individual or organizational healthcare provider, or perform advanced searches based on provider name, location, type of service, credentials, and many other attributes 1. Once installed, you can use the package to search the NPI Registry and return the response as a tibble with high-cardinality data organized into list columns 1. The package also provides convenience functions for data extraction so you can spend less time wrangling data and more time putting data to work. ...

I need a flexible template (Excel or other tools, if beneficial) for the display of Benchmark results. Attached is an Excel sheet showing the input (columns) and the output (chart) that is close to what I need (but it is not easy to change and it doesn't look so good). I need to be able to select specific rows for the display, add or remove lines, maybe add a second column "reference price 2". Ideally I select rows with a specific "selector" and as a result the chart changes (displays only the selected rows). It should not be too complicated but I think an expert can handle this a lot more efficient.

All work is done in Androids 4.1 kit-kat or higher Import and export data in XL.s format or raw CSV the 12 columns of calculation and search are made in XLs Each item has its box on display and by touching or scanning or by name, Price, Category, or sub-category item will appear on screen for example 149000049930 Coca-Cola 8.5 oz bottle next row QTY 10500 X Price 1.29 Equal sum = $13545.00 149000049930 Coca-Cola 8.5 oz bottle next row QTY 10500 X Price 1.29 Equal sum = $13545.00 149000049930 Coca-Cola 8.5 oz bottle next row QTY 10500 X Price 1.29 Equal sum = $13545.00 at the bottom total quantity and the dollar value will upload file to with milestone Give us a final price make a video if can be done we approve the design will pay...

Hey All, Hope you guys are having a great day! As the title says, I need a simple scraper on my website that will scrape and store information based on my inputs BACKEND I will input into the...doesn't scrape the same tweet twice. Frontend UI Input Feilds I need a simple Frontend on my website with the following, no design necessary, just the fields: - List of Twitter Accounts - Minimum Number of Likes - Minimum Number of Retweets - Start/Stop Button - Parsing Interval Output Fields - Column 1: Tweet Text - Column 2: Tweet Link - Columns 3: No of Likes - Columns 4: No, of Retweets - Columns 5: Images or video (if available) - Columns 6: witter User Account Start your proposal with the word orange so I know you read this. My Budget is $5...

Vui lòng Đăng Ký hoặc Đăng Nhập để xem thông tin.

I'm looking for a freelancer to help me generate line graphs based on finance data stored in 5 separate Excel tabs. The graphs should emphasize a few, specific data points as specified by me (columns c,g and I) then put on graphs tab. My preferred format for the final deliverables is an Excel file. With your expertise, I'm confident that the data can be presented in an effective, graphical format that will help make individual trends and relationships clearer to my team.

Develop Mirth connect channel to fetch data mentioned in specification document > message structure from HL7 messages. Create database tables and columns to store data mentioned in specification document > message structure. Insert data from HL7 messages to database.

I am looking for a skilled freelancer who can help me with an experimental project in the derivatives market. Specifically, the project will focus on options trading. Whats required? 1. to be able to save tick level data (of the next expiring option chain) in local system 2. create separate options using option pricing model and save the pricing along with above 3. the columns in db should be time, strike price, option price, call/put, oi, volume, buy qty, sell qty (all of these are readily available in the api) + option price based on option pricing model 4. just connect the above database to powerbi (no need to build anything in powerbi as i will do it myself) but the data should be realtime and not refreshed based on hitting refresh button What will you have? 1. api login and...

I am looking for an Excel specialist to help me with a project. The desired output is to create formulas using vlookup to update one spreadsheet. I don't have specific columns in mind for the vlookup, I would like the Excel specialist to use the data to determine which column to use. There are no other Excel tasks related to this project. The task is to simply combine two spreadsheets using vlookup and the data provided. If you have expertise in Excel and this sounds like something you can help with, please let me know.

Hi there, Looking for the attached PDF to be made into an excel sheet. with a table first page to link to drop down menus on the second page that should look like the PDF, the laminate,profile and type columns require the drop down menu. looking for this asap. thanks!!

...- Data Analysis Report: The freelancer will provide a detailed report on the analysis of the available data, including insights and recommendations for improving prediction accuracy. - Documentation: Clear documentation of the developed model and its implementation process will be required. the source code of the current model is in the link below. You have to increase the accuracy of these columns. [Probability_win] [Probability_Lose] [Probability_Draw] [Expected Result] ***the reference of methodologies: ***

...assist me with a data management project. The project involves downloading 15 separate contact lists from our pharmacy management platform, removing duplicates from the lists, re-formatting the columns according to a specific template, and uploading each list to the corresponding pharmacy's WooDelivery account. Pharmacy Management Platform: Rx2Go - The freelancer should be familiar with the Rx2Go pharmacy management platform. Column Formatting Template: - I will provide a specific template for the column formatting. - The freelancer should be able to follow the provided template and re-format the columns accordingly. WooDelivery Accounts: - All WooDelivery accounts for each pharmacy are already set up. - The freelancer will not need to assist with setting up any ac...

I am looking for someone to write a python code to scrape a specific website for me. I need the code to scrape only text content from the website, though the end result should be organized and cleaned for better readability. In other words, the python code should be able to parse the data into neat rows and columns. I am willing to provide additional details to the freelancer once a project has been finalized.

Hi, I am looking for a vanil...attached section You will require to do the following actions: 1. Load the data with default filters (screenshot attached, can share code if needed) 2. Disable default filters on the skills column (screenshot attached) 3. Create a custom function that calculates all the unique skills in the skills column (to be done) 4. Render a replica of the default filters where one can select a skill and the columns get filtered with the multiple selected skills (to be done). a) This will require to add an event listener that will create a dropdown; b)a function that loads the unique skills with multi select c) An event listener that will render the filtered handsontable when one or more filters are selected d) An event listener to close the filter (have code, w...

I am looking for a skilled individual who can complete a series of architectural drawings for various projects. The ideal candidate will have experience in creating highly detailed drawings with multiple views. we supply mezzanine floors for our customers and we would like someone who is able to draw great drawings in a quick timeline. i have attached some sketch examples on what we would supply to you for you to fill out. Requirements: - Expertise in architectural drawings - Ability to work with exact specifications provided by the client - Attention to detail and ability to create highly detailed drawings with multiple views Skills and Experience: - Proficiency in architectural drawing software such as AutoCAD or SketchUp - Strong understanding of architectural principles and constr...

I just need a simple data table with 5 columns and 2 rows.i build it already but cant make it responsive

*** I AM BEHIND ON PROJECT DUE TO PREVOUS FREELANCER unable to complete ... SO THIS IS A LATE PROJECT.!!! ***** I simply would like a 360 rendering of an interior ...3d model of the open space to scale as presented in pdf file. 2nd -- Add 3 Large elements to space so that we can be visualized and built within the room. 1. Waterfall (element 1) 2. Book shelf (element 2) 3. Puja Space (element 3) I would like the Render to be exact size so that materials can be purchased to build I have provided the measurements of the room and all walls, columns, arches, windows and corners. via PDF. *** i would LIKE if possible Rendering be built expecting .OBJ or .FBX extension for Oculus to be imported or built into "Unity 3D" or Unreal Engine platform*** BU...

...outlined in the attached dashboard. Those who are willing to work on it should be able to connect with me for a voice call discussion to better understand my requirement. Important thing is, after you design the login page and the dashboard, it should be made in such a way that I should be able to update the details under each user dashboard easily like some kind of form filling or so, because 2 columns in their dashboard needs to be updated by me on regular intervals like once in a week or so. There is no need of any hosting space, domains, emails or anything, I have all the things already in place. I just need the following updates in my site which should be done from my wordpress admin login The description may be long so please take time to read and understand before respo...

I have data in a data table (read in from file). It is one column with names that have a period in them. I need a function to take this data and convert it to columns. Each column would be the values that have the same part before the period. They must be ordered in the order they appear in the input file. Attached is a sample file with the data and a screenshot of what the output return datatable should look like. The amount of items per group could vary. I need this fully tested with good code and performance. Max Bid: $15 There are way to many automated fake bot bids...you must start reply with today's date.

I use a php script called Machform. After a user fills out the form, i want them to be shown an image they can download that contains the form data they entered. I need a few extra features: 1) After a user fills out form, on the confirmation page i want a dropdown displayed that allows the user to select the image to generate. 2) Then the image script should run, take specific values from the form, insert them into an image (which has a background image) in specific places and present the user with the finished image. 3) The image should also contain a barcode based on the userid they chose and a QR code that links to a page that displays the image (this page would be public so that users can share it). A query string would need to be appended to the end of the php filename to display t...

Sql Query Parse Join Columns. I need a way to parse sql queries and build a list of used in the join criteria. 1-Needs to be able to paste text (queries) in a textbox or load from a file. They can be many stacked in one file. 2-It needs to extract the join criteria from the queries. 3-It needs to format in a tab delimited file. +Tabe delimited. +Schema and table name written out (not alias) and combined. 4-If there are more than 1 criteria between 2 tables (meaning joining on more than 1 column), they both need to be listed and have a unique group number associated (that does not exist in the output file). 5-If the join is between a nested query (a derived table), that join does not need to be included. Only table to table. 6-The output file can not have duplicates

...for houses with more than 2 floors. (1st Floor, 2nd Floor and Basement). This project is for the extension of an existing house. The existing house has 2250 of living space and I am adding another 3000 SQFT to the existing space. What I am looking for? For all three levels and the entire house (close to 5250 SQFT + 2 Car Garage) -Foundation and dimensions -Framing details -Details of beams and columns -Wall sections -Roof Framing Details -Connection details -Project completion will be considered as when permit is acquired so it is expected that engineer will provide updates to acquire the permit if needed. - The deliverable includes all editable files Description The project involves expanding the existing house, specifically at the rear, where the current house measures 2250 ...

I need a script that allow user to upload an excel file and download images stored as URL in a column. I attach example file of the excel.. are the columns S and T that needs to be downloaded in bulk. The name of the downloaded images should be the ID of the column A plus a "_1" for the column S and "_2" for the column T. Example of the row 2: (filename of column S) and (filename of column T) Can be a MACRO for excel 2013 or an online script that allow to upload excel and download images.

Hey, I have two more small tasks for the same project if you're available? I was hoping to add a feature to the app where the user can choose between greater than, less than or equal to in the Production Budget and Worldwide Box Office columns. The query that they enter can then filter those values so that they can see if the data is above, below or equal to that query. I was also hoping you could add unit tests for the filter and sort features you implemented recently. Are you available?

could you please separate the first and last names in the first column into two columns? please also remove dr/md/any titles like that. ex: column 1 reads joe smith MD to column 1 reads joe column 2 reads smith

I am looking for a freelancer who can help me create an Excel spreadsheet to organize my financial data. The spreadsheet should include formulas and computations to perform calculations. Skills and Experience: - Proficiency in Excel and experience with organizing financial data - Strong understanding of formulas and computations in Excel - Ability to create a spreadsheet with 50-100 columns and rows - Attention to detail to ensure accurate data entry and calculations

...ONE DASHBOARD AND 5 WIDGETS ​ ​Tables to use:​ ​ Invoices Invoice Items Customers Credit notes DONNEES MANDATAIRE ACHAT ANNONCES OK ​ ​Columns in the 5 reports:​ ​ ​ Date​ ​ number​ ​ order​ ​ D'ORIGINE​ ​ name​ ​Invoice total (BCY)​ ​ DU JOURNAL​ ​ACHAT ANNONCES du lignage​ ​ACHAT ANNONCES de rétrocession du journal extérieur​ ​DONNEES du mandataire​ ​DONNEES de rétrocession​ ​Credit Note Number​ ​Credit Total (BCY)​ ​​ ​ ​ Make 5 reports different with these columns according to some filters in order to calculate 5 aggregate formulas (the result must be used in other reports):​ ​ ​I-Rapport d'export

Vui lòng Đăng Ký hoặc Đăng Nhập để xem thông tin.

To help with my work relating to spatial data, I need someone to help write a code for me that achieves the following; Read in a for-loop and store the 5 selected table columns/attributes in a two-dimensional list / list of lists Sort the list from high to low by one of these attributes Create an additional list or extend the existing list with an attribute that will contain a classification name based on the error value Output the newly create list as a text file. Priority will be given to those who can complete in a faster time frame

I am looking for a Salesforce LWC developer who can develop a new Salesforce Lightning Web Component. Attached screenshot. You can have only two columns from account object to show on screen. Both table are same. 1. In first table Transfer From: If Account balance is less than $10, disable that row On load of lwc 2. If you have selected any row in the first table, disable the same row in bottom table.

...commands, binaries, Excel macro programming, VBA programming). You can validate my experience in this link: https://www.freelancer.com/u/araquelus I can help you with your Power BI project. Also, I can help you with my business experience creating KPIs that can help you make long-term strategic decisions. I have knowledge and experience in: - Databases with more than 500k rows and more than 100 columns - Run DAX queries and functions in Power BI - User access security and control panel in the web service. - Connecting Power BI to Api - Good knowledge of SQL queries, views and procedures. In my portfolio I have dashboards related to the Sales, Purchasing, Finance and Inventory business process, check out the following link: https://www.freelancer.com/u/araquelus Hourly rate $2...

...competitor backlink-building tasks. The ideal candidate must possess fluency in English along with a comprehensive understanding of SEO techniques and tools, particularly related to Backlink Building. Roles and Responsibilities Managing a Google doc monthly, which includes various sheets detailing competitor backlinks. Securing links from the specified domains and recording these in the allocated columns. Key Requirements - Proven experience in backlinking. - Exceptional English language skills, both verbal and written. - Comprehensive understanding of the business or product. - Broad knowledge of SEO and backlink building. - Strong organizational skills. - Strategic thinking skills to generate content that attracts quality backlinks. Who Should Apply We are looking ...

We are looking to undertake a project on two Power BI Datasets. We need to reduce the memory and processing power by transferring Power BI Desktop Calculated columns to Power Query (M) or where necessary SQL. A review of the processes in place will also be undertaken so that upon completion we have more efficient Datasets. Skills and Experience Required: - Proficient in Power BI and DAX formulas - Strong understanding of M language - Experience working with datasets of moderate to large sizes - Ability to handle complex DAX formulas and convert them to M language efficiently - Knowledge of SQL is preferable - Attention to detail and ability to troubleshoot and debug any issues that may arise We are looking for someone with the right experience and skillset who has previously worke...

I am looking for a freelancer who can help me extract table data from a pdf file. The table in the pdf file is a simple table with rows and columns. I would like the extracted data to be transferred to an Excel file format. There is no need for any specific data cleaning or formatting after extraction, just the extraction itself is enough. I need to extract every nations' data of fields below( only extract value is enough) Quality of roads Quality of railroad infrastructure Quality of air transport infrastructure Quality of port infrastructure Quality of electricity supply about 130-150 nations. Please check the for data to be extracted, and the output format is Skills and experience needed for this project: - Proficiency in extracting table data from pdf

I am looking for a freelancer to create an inventory report template for me. S...freelancer to create an inventory report template for me. Specifically, I need the report to include all product names, quantities on hand, par levels, and quantities need ordered.. The template must be compatible with Microsoft Excel software, I use an inventory tracking software called Sortly. Sortly imports inventory data entered by employees to Excel. As for the layout, I prefer a table format with columns and rows. I have a vision for how the template needs to flow, I do not have the expertise to design the formulas to get desired results. This report template must be easy to use and update, but also visually appealing. If you think you are the right fit for this project, I look forward to hearing...

I'm in search of someone who can help me c...importing it into Excel. Here's a quick example of what I need: 1. Input (PDF file to upload to Google Spreadsheet): Attached to this post. 2. Output (the spreadsheet): Data parse example: a. Discard the pages without a table. b. Remove the row without cells (dates) c. Split name in 2 different columns (first name / last name). d. On column "C", exclude rows with strings that starts with a "K". e. Column D, remove the "MIDD-" string. f. Remove unnecessary columns. g. Add a "-" to the "PIN" number. If you think you can assist with this, please let me know, and I'll provide you with extremely detailed information about the project. It's a project that n...

The application that I have uses a table to display data. I would like this data to be filterable and sortable. Each column in the table needs to have an input field. When the user types, the data in the table should show and hide depending on the entered search term. Your solution should also have the ability to combine filters from multiple columns to get a very granular result. The solution should return a result where ALL filter conditions are met instead of any of the filter conditions

...terms (sourced from an Excel file) in their respective top 20 countries. Concurrently fetch the top related keywords for each term. Technical Requirements: Python Version: The script must be developed for Python 3. Operating System: The script should run efficiently on Windows. Input: An Excel file with a list of 14,000 keyword terms. Output: An Excel or CSV file, structured with the following columns: Keyword Term Country Search Quantity for year 2022 Search Quantity for year 2023 Top 5 Related Keywords (comma-separated or similar) Performance and Robustness: The script should be optimized for efficiency, especially given the potential Google API rate limits. Strong error handling is essential, particularly for issues tied to the Google API (e.g., quota exceeded, timeouts). ...

... The roof is flat. The building is made of brick and brick columns and its style and color must be matched in your rendering. I would like the rendering to be as realistic as possible. The building is L-shaped. Because two sides butt up to existing City sidewalks on the south and east sides, each townhouse should be set back 3 to 6 feet, as possible, on the south and east sides. You only need to concern yourself with the south or east side, or even one unit on any side you choose. The elevation drawing was originally done to make the entire building a commercial space. It shows a series of glass storefront windows. THIS IS NOT WHAT WE WANT NOW so get that out of your head. Instead, it is important to use the brick columns as the demarcation of each unit, and to add...

...journal reference keywords and automated matching, and using Excel and R (statistical) packages. Accurate and timely completion of this project is essential. If you feel that you can fulfill this task, please contact me to discuss further details and project progress. Background: I have two data sources. 1. A Pubmed download, consisting of 441848 rows (each a journal article reference) and 44 columns (Unique ID, Author, Year, Title, abstract, Keywords etc) The Pubmed output keywords column contains all words by which each article is marked. 2. The list of Medical Subject Headings (MeSH) is from the United States National Library of Medicine. MeSH is a hierarchical framework. The MeSH list contains 36056 rows listing the keywords from the 16 areas by which papers are c...

I am looking for someone to automate a Word document using an Excel table. The data to be automated is text, and I have a specific template in mind that I'd like used. The data I need to be automated is relatively simple, with only a few columns and rows. If you think you have the skills needed to complete this task, I would appreciate it if you could post a proposal as soon as possible. Thanks!

Project Description: I am looking for a skilled developer to fix issues and add additional functions to the Chartjs WordPress plugin for TablePress. The specific requirements for this project are: Bug Fixes: - Fix Horizontal, Stacked Horizontal, Bubble and Scatter Charts Additional Functions: - Add Mixed Chart of Bar and Line, columns defined by 2 attributes: bar and line Timeline: - The desired timeline for this project is within a week. It is important that the selected freelancer is able to complete the tasks promptly and efficiently. Requirement: - Use the source version, do not use the lastest TablePress. Programming Language/Tool: - The client does not have any specific preference for the programming language or tool to be used. They trust the freelancer's judgement...

Project Description: I am looking for a skilled developer to fix issues and add additional functions to the Chartjs WordPress plugin for TablePress. The specific requirements for this project are: Bug Fixes: - Fix Horizontal, Stacked Horizontal, Bubble and Scatter Charts Additional Functions: - Add Mixed Chart of Bar and Line, columns defined by 2 attributes: bar and line Timeline: - The desired timeline for this project is within a week. It is important that the selected freelancer is able to complete the tasks promptly and efficiently. Requirement: - Use the source version, do not use the lastest TablePress. Programming Language/Tool: - The client does not have any specific preference for the programming language or tool to be used. They trust the freelancer's judgement...

I have a website that needs a new custom PHP page. The work involves * Modifying the current MySQL table to add more columns * Editing an existing script * Adding a new dynamic page based on the contents in the table.

I am looking for a skilled SQL developer to assist me with a query for updating the "MyContacts" table. I need to update specific columns in the table, specifically the "ContactInfo" columns. I have two tables and trying to Update first one by concatinating values from and but I need to concatinate only unique values. Skills and Experience: - Strong proficiency in SQL and SQL Server - Experience with writing complex queries and updates - Familiarity with concatenating strings in SQL Server - Attention to detail and ability to accurately update specific columns

...of the project: Timesheet Organization: - The timesheets should be organized by month. Timesheet complexity: - printed timesheets show 14 days but only a few are populated, unpopulated days should have NA or zero in start and end times. - data has mixed of printed sheets and handwritten sheets. Format or Template: - I will provide the format for the timesheets. Number of Columns: - Each timesheet should have 5 columns (employee name, date, start time, end time, break). Skills and Experience: - Proficiency in MS Excel is required. - Attention to detail is crucial to accurately input the information on the timesheets. - Previous experience with data entry or similar tasks would be an advantage. If you are interested in this project, please let me know your availability...

Make a python script to fetch data as csv from Starshipit API on daily basis. Starshipit operates on a Parent and Child set up = Our...a python script to fetch data as csv from Starshipit API on daily basis. Starshipit operates on a Parent and Child set up = Our parent is in AU and the Child is in the USA. The Child is where you will pull the data from. Data is about tracking numbers, recipient addresses, and item descriptions (attached a sample for that.) Data you have to fetch is in Columns A to N Columns O to AB are fixed static values always remain same in every csv. only collect the data for that day and not privous dates (like 19/09/2023) After retrieving data, email csv to us. Deploy the code on my digital ocean vps.

I wanted to find a way to do some nice infographic of small maps showing priority locations against each activity or project location. Something like attached but only for one country like USA based on excel data. I will share sample data. So using the columns c to show target and then d-k on priority locations by color coding governorates inside country on map for each indicator in a and b.