Pandas percentage of each value in columncông việc
OLDED: Script is running on 1> Old script: Script (rename file to .js) 2> Old interface: UI + NEW: Re-write new Script with new interface to be able to run on 1> Design interface + default value: B1 - Script 2> Detailed description of the function: B2 -Note for the 3> Script to check the results: B3 -Test Cases (edited # 2) .png
...as a Data Scientist, and have deep understanding of statistics. My mentor would have examples and documents, to help me learn the followings: - Statistics, including Probability Theory. - Logical Thinking: How to understand business requirements and convert them into research tasks, how to use data to find new insights, how to conduct research, how to make conclusions from research. - Skills as a Data Scientist: feature and relationship analysis, tests (t-test + p-test), big data... - My mentor can assign me tasks to improve my skills, review my work, give me feedback, answer questions. I have experience in python, numpy, scipy, pandas, matplotlib... But I am especially finding logical thinking and statistics challenging. I can study in either Vietnamese ...
This short video will demonstrate what I need that will automatically insert a timestamp into my Google Sheets document each time new data is entered. Key Requirements: - The time stamp should consist of both the current date and time. - The script should insert the time stamp in the column immediately to the right of the cell where new data is entered. - The format of the time stamp should be fully customizable. Ideal skills for this role: - Proficiency in Google Apps Script - Strong understanding of Google Sheets - Experience in developing scripts for automated processes - Ability to create customizable timestamp formats - Excellent problem-solving skills and attention to detail Please include any relevant experience wi...
...relative position of the window to North. It just need to be north, south, east and west. The script will do the following: Add a property to the glazing or curtain wall structure (if it includes glazing) that determines it's orientation to true north. It should either: Only do this to external windows (windows or curtain walls embedded into external walls), or in some instances, I will need to manually override what is an external wall. So it may be best to create a script that first assigns a property external wall = true, then use this for a second dynamo script to get the orientation of windows in the external walls based on the property set. Ideally it would then create a schedule with all the external windows with the following properties: Wi...
I'm looking for someone who can proficiently print names and addresses on standard white envelopes. - Envelope Details: All envelopes are standard white and require nothing but names and a...addresses on standard white envelopes. - Envelope Details: All envelopes are standard white and require nothing but names and addresses. No logos or other branding elements need to be worried about. - Printing Requirements: All names and addresses should be clearly printed. While I value efficiency, the quality of work should not be compromised for speed. Ideal skills for this job would include accuracy, meticulousness, and a solid grasp of both formatting and the English language's written form. Previous experience in relevant fields will be considered a def...
I'm looking for a skilled developer who can enhance my existing EMA based strategy on TradingView by adding Take Profit (TP), Stop L...developer who can enhance my existing EMA based strategy on TradingView by adding Take Profit (TP), Stop Loss (SL), and re-entry features. The primary goal of this enhancement is to improve the profitability of the strategy. Key Requirements: - Add TP and SL: The TP and SL values should be calculated as a percentage of the price. - Re-entry: Implement a re-entry feature based on the strategy's signals. Ideal candidate: - Proficient in Pine Script and TradingView platform. - Experience in developing and enhancing trading strategies. - Strong understanding of risk management in trading. - Abi...
Calculator: The calculator should be written in PHP and be compatible with Bootstrap for customers (for our bootstrap website). It should fetch the current Kitco market values and cache them as needed, possibly using a crontab. The output price is always for Fine Gold, 999. The customer should be able to select karat numbers such as 8K (333), 9K (375), 14K (585), 18K (750), 21.5K, 22K, etc., to display the current market price according to the karat numbers. It should display as follows: Estimated Value: [current market value] Maximum Pawn Amount: 50% of the market value It's important that no other API is used, but rather prices are fetched from kitco.com. Additionally, at the beginning, customers should be able to select Gold, Silver, or Plati...
...error message stating, "The value of the setting "max_input_vars" must be increased to 5000 in order to be able to submit the product form." Key aspects of the project include: - Identify the root cause of the error message regarding the "max_input_vars" setting. - Fix the bug in the product form that's preventing me from submitting it. Ideal skills and experience for this project are: - Proficient in PrestaShop, specifically version 1.7. - Expertise in PHP and understanding of PHP settings. - Experience in debugging and fixing product forms with numerous declinations in PrestaShop. I have a bug which is not constant, on a particular reference of the site the 4301...
I'm in need of a skilled developer who can optimize my website's performance by altering the stylesheets and .htaccess file. The specific changes I need in the stylesheet are: stylesheet does not work on Google Chrome On Firefox and on Safari no issues The booking widget from is not loading which might be rather a stylesheet issue than .htacess on Google Chrome and the stylesheet for the header links does not work On Firefox and Safari the widget is loading, just load the site on different browsers and you will see For the .htaccess file, I need: All links on the left column are resolving to .hmtl but it should resolve to .php One example: Now the links (pages ) are not loaded but if you change the links in the browser line to .php ...
...the design of my page created with Elementor. Currently need it it for desktop version. Please note: I am not looking to rebuild, redesign, install new themes, or anything similar. Please refrain from sending messages suggesting such changes. My website is generally fine as it is. I'm just looking to enhance the page design to make it more visually appealing by adding a bit of color, perhaps some colored lines or a subtle background,maybe by creating more colums or adding some banners or icons. These small changes should make the page look nicer and more professional without drastic alterations. I need someone with a good sense of style who can refine my page to look more professional. Please respond if you have experience in stylishly enhancing Elem...
Seeking skilled debt consolidation professional to address my business's current financial challenges. Currently, we are grappling with over $100,000 in business loan and credit card debt. Our primary approach has been to cut expenses, which helped to a certain degree, but hasn't fully addressed the problem. We are open to other strategies, including debt consolidation, to find a practical solution. Ideal freelancer should have: 1. Proven background in Financial Planning or Debt Management 2. Experience dealing with business loans and credit card debt 3. Strong problem solving, strategic, and planning skills 4. Previously demonstrated success in helping similar businesses minimize and manage their debts.
Vui lòng Đăng Ký hoặc Đăng Nhập để xem thông tin.
...designer with expertise in Figma to create a comprehensive company profile and documentation overview for our platform. This document will serve as a key resource to communicate our brand, values, and the unique aspects of our platform to potential customers, investors, and partners. About Us: The increasing demand for diversified lending solutions led us to develop a single platform, making it easier for brokers and introducers to manage and offer a holistic commercial financial solution to their clients. Objectives: - To create a visually appealing and informative company profile/documentation overview. - To clearly communicate our company's history, team, and future direction. - To highlight the key features and benefits of our technology. - To detail the ...
...mission is to create a pop culture-themed t-shirt art that: - Features mild caricatures of three subjects, namely Joe Biden, Donald Trump, and an ice cream cone. - Portrays Joe Biden in a headlock, from Donald Trump, struggling to try to lick an ice cream cone. - Presents the caricatures in a semi-realistic manner, exhibiting your understanding of both artistic detail and caricature style. - Utilizes an appealing blend of the comic-style with minimalist elements, drawing on your experience with these forms. For this, I anticipate an artist with proficiency in caricature and pop-art along with a good grasp of modern cultural icons. Familiarity with political figures and a sense of humor will definitely add value to the pr...
As a burgeoning digital car dealership with a unique proposition of providing new cars without a waiting period and discounted rates, we are now poised to supercharge our growth trajectory. We are seeking an experienced business development strategist with a proven track record in the automotive industry to help us identify and engage with strategic investors. Key areas we need assistance with include: - Building a comprehensive list of potential strategic investors who align with our business vision and goals. - Developing a targeted communication plan tailored to each prospective investor. - Crafting compelling pitch materials that showcase our unique value proposition, market potential, and competitive edge. - Strategizing and advising on negotiation...
How to modify the Prototype properties of a Navigator object that can be viewed using the navigator command in the browser console. You must edit the Prototype properties at the lowest level in the object list to change the platform value of userAgentData
... Then the hat should fall from the to and land on the letter C Here’s what I have in mind: - Duration: I'd prefer a quick and punchy animation, no more than 5 seconds long. - Emotion: The animation should evoke a playful and happy mood. - Creativity: I'm open to suggestions on how to make this logo animation unique and attractive. This project needs a professional with a strong grasp on creating and implementing 2D/3D animations. Experience with logo animation and an ability to capture essence of a brand will be a plus. Good communication is key as I value active update on the project's progress. It's crucial to get the rabbit's details and movements right, which could require a higher level of skill in fine detailin...
I'm seeking a skilled data analyst to eva...my company on a weekly basis. I'd like to conduct this analysis using multiple measures - by percentage, number of employees, and over various time periods. As the ideal candidate, you'll have: - Proficiency in data analytics - Experience with employee data and turnover metrics - Ability to offer insights based on complex data - Capabilities to deliver weekly reports and insights Your task will include: - Parsing sales, customer, and financial data - Calculating turnover rates in terms of percentages, numbers, and durations - Producing a report every week with a detailed analysis of findings. Your ultimate goal will be to use data to help understand and reduce our turnover rate. Solid e...
...thrive in a fast-paced environment where your success is directly tied to your effort? Are you passionate about connecting businesses with the power of a stellar website? If so, we want YOU on our team! We're a High Converting Website Design Agency looking for a driven, commission-only sales superstar to join our ranks. In this role, you'll be responsible for: Prospecting and Cold Calling: You'll identify potential clients who need a website refresh or a brand new online presence. Be prepared to make a positive first impression and build rapport over the phone. Understanding Client Needs: You'll have a knack for uncovering a client's vision and translating that into actionable website goals. Selling Solutions: You'll present our web d...
I'm looking for a talented web designer who can build an engaging, minimalist website on WordPress. The ideal candidate should have: - Proven experience in designing and developing WordPress websites - Proficiency in minimalist design aesthetics - Strong ability to make the site mobile responsive I value consistency in design, ease of use, and simplicity. If you can balance these elements while creating a memorable digital experience, then this project is for you.
I'm ...to work on a video of more than 5 minutes for entertainment purposes. Key Requirements: - Proficiency in video editing software (e.g., Adobe Premiere Pro, Final Cut Pro) - Previous experience editing long videos - Ability to understand the entertainment aspect and create a visually engaging video - Creative skills to potentially suggest improvements or add-ons to enhance the video's entertainment value The video will need to be cut, trimmed, and potentially have text and/or titles added. I'm open to ideas and suggestions for making the video more engaging. Experience in editing entertainment content, or at least a strong understanding of what makes a video entertaining, is a big plus. Please share any relevant work samples or por...
I have a lot of data in a spreadheet. Have a look at attached spreadsheet. I need the sheet named "auto made" to be automaticly made. (it is now manually filled with data) What triggers data to be in "auto made" sheet is the value 1 in Ordre!B column. If no value in Ordre!B column the "auto made" sheet will only have headers. Description on where the data is from is described in row 10 in "auto made" sheet. This row 10 need to be deleted to make the spreadsheet work for my import
...opening of a box of trading cards and will highlight the value of each card pulled to demonstrate the potential profit or loss from the initial purchase price of $140. **Objectives:** - Create an engaging 30-second video suitable for social media platforms. - Visually represent the starting cost of $140 on screen. - Highlight and count the value of each significant card pulled from the box. - Display the cumulative value towards the initial purchase price. - Conclude the video with the final profit or loss from the box. **Video Requirements:** 1. **Introduction:** - Start with a clear display of the initial purchase price: $140. - Briefly introduce the concept of the video (e.g., "Can...
I'm in need of a freelancer who can help me parse my VCF file and convert it to a different format. The main goal of this task is to extract the genotype information from the file. input will be VCF file (from ONT whole genome run) and csv file with columns containing rsID, chromosome number, position. output will be same as input csv file, with extra column showing genotype from VCF at the given position can run on Mac shell so either perl or python would be fine. Ideal Skills & Experience: - Proficient in parsing VCF files and understanding genotype data - Experience in converting files to various formats like CSV, TXT, and XLS - Attention to detail to ensure accurate extraction of the data - Knowledge of any data validati...
I'm in need of an draftsperson to design a site plan for a small RV park in Maricopa County, Arizona. Key requirements: - Design 6 RV spaces in the park, each needing a Water hookup, Electric hookup, and Sewer hookup. - The size of each RV space should be minimum of 25 feet wide with 1250 square feet to comfortably accommodate vehicles and meet the local code requirements. As the project owner, I'm looking for the following in your bid: - Relevant experience in designing RV parks or similar projects. - Your proposed approach to meet the specifications and local regulations. - Any additional value you can bring to the project. Looking forward to your application!
I'm in need of a Stable Diffusion expert who can create a set of workflows for my web application. The main goal is to achieve the highest percentage of character and image consistency possible The workflows should: - Creating a character from a chatbot prompt/preset selections - Inserting characters (user can insert multiple) into images given but a chatbot image description, in different poses, interacting with prompts etc.. Please let me know the highest percentage of detail consistency you can achieve using Comfy ui workflows.
I am seeking a professional graphic designer to create a ...should adhere to the following guidelines: Design Style: • Classic: I prefer time-honored logo designs that ooze character and enduring value. Color Scheme: • The main colors should be blue and white, representing cleanliness and precision. Symbol Incorporation: • The logo should include the images of a car and water droplets, symbolizing the core operation of the business. • The addition of a dog and a classic mini car will add a unique touch to the overall design. Ideal Skills & Experience: • Proven experience in graphic design and logo creation • Ability to convey complicated concepts through simple designs • Excellent understanding and implementati...
Vui lòng Đăng Ký hoặc Đăng Nhập để xem thông tin.
I'm in need of a talented React.js and developer to build the frontend of a new SaaS website. The design should be centered around bright and vibrant colors, offering a welcoming and engaging user experience. Key Functions: - Subscription Management: The website should provide users with the ability to manage their subscriptions seamlessly and efficiently. The website's design is crucial to its success, and while I don't have detailed wireframes, I do have a rough sketch of the layout. This should give you a starting point to work from, but a creative touch in the design process is definitely appreciated. Ideal Skills: - Proficiency in React.js and - Strong eye for design and detail - Experience with SaaS website creation and ...
Looking to collaborate with Antenna experts for design/build of RFID UHF 860-960 MHz Active Digital always on antenna. It will support any RFID tags of the stated frequency range and the protocol. We have identified some possible technologies below but will rely on your expertise to pick one or combination of these or another suitable one from your experience. If you know of a pre-built solution that will be ideal. This antenna will be connected to our MCU via a comm port and be fully software defined. Our objective is to accomplish a 0.3 meters x,y,z 3D planer precision location of RFID UHF passive tags at about 25 meter cone at about 8 meters height from floor. Must be RFID UHF Frequency range (roughly 860-960 MHz, supporting US, Europe, Asia spectru...
My project involves the planning and design of trusses for a roof with a 132 psf rating. The rooftop must have a shed style design. I need a engineer stamp. - The maximum span of the trusses is less than 20 feet. - The trusses should primarily be constructed from wood. Ideal project candidates need extensive experience in truss design and engineering, a familiarity with a variety of materials, but specifically with wood, and a solid understanding of shed style roofing. Previous experience in designing structures to withstand specific weight ratings, like my project's 132 psf, is of great value too. The project should be completed within efficient timelines without compromising on the quality.
I'm seeking an experienced financial analyst to conduct a detailed comparison of the long-term wealth accumulation of purchasing a home with a mortgage vs continuing to rent. Key Components: - Assess potential financial outcomes of both renting and purchasing a home - Focus on long-term wealth accumulation - Take into account anticipated changes in property value over time Ideal skills and experience: - Proven experience in financial analysis, specifically around real estate - Familiarity with property market variables and predictions - Ability to present data in a comprehensive yet understandable manner.
...and state inputs to enhance user experience. ** SEO and Security Setup: - Implement comprehensive SEO strategies to improve organic search visibility and ranking. - Set up SSL through GoDaddy to ensure the website is secure and trusted by visitors. ** Database Management: - Integrate Google Sheets with the MySQL database so that the rates can be updated weekly via Google Sheets instead of directly through the cPanel, simplifying maintenance and updates. - Ensure seamless data synchronization between Google Sheets and the MySQL database to keep the quote system accurate and up-to-date. ** Deliverables: - A fully redesigned WordPress website with a modern look and maintained content. - A fully functional, tested, and bug-free instant quote form. - SEO setup and opti...
I need a skilled developer for API integration between Postman and a handbag wholesaler. The assignment will include: - Configuring API integration and data syncing. - Automated testing, with emphasis on endpoint validation, authentication testing, and load testing. Skills and Experience: - Knowledgeable in Postman and API integration. - Previous experience validating and testing APIs. - Will be provided with specific API endpoints for validation during testing. I value clear communication and expect timely results.
...seeking an expert in Excel, OneDrive and email notifications who can develop an automated system for me. This system needs to: - Monitor a specific Excel file within my OneDrive for business for cell value changes. - When changes occur, the system should not send an individual notification for each. Instead, it should group updates together. - These grouped updates should then be sent as a single email to a preselected set of recipients at a specific time interval. - Crucially, the email should not only contain the updated cell values but also their previous values, enabling recipients to easily compare old and new data. Only experienced Excel and OneDrive professionals should apply, preferably with a background in automated data notifications. Famili...
...listings, where I can feature a range of available houses. - A contact information section is essential. This should include a form for potential clients to fill out, as well as my phone number and email address. - Customer testimonials section is also needed. This should be a space where previous clients can leave reviews of my services. Additional Features: - I'd also like a 'home value link'. This is a feature where potential clients can input their address and receive an estimated value of their property. Logo: - A professional and eye-catching logo that resonates with the real estate industry. The logo should be versatile and suitable for both print and online use. Ideal Skills: - Proficiency in web design and ...
...full-color gifs, each depicting a necktie being cut. The cutting of the tie symbolizes the first sale. These gifs will be used for two separate businesses, hence, the need for two. Key elements to include: - Both the gifs must incorporate 'Logo A' and 'Logo B'. - The gifs should be in full color. - Text must be included. The specific texts will be provided. They should be visible throughout the entire gif. Ideal skills for the job: - Attention to detail will be important to ensure that logos and text are incorporated correctly and clearly. - Proficiency in making gifs. - A sense of humor and creativity. This task doesn't call for a stiff, formal design! - Prior experience in creating gifs for businesses would be ben...
...YTD Sheets: Incorporate tables of accounts for 12 months and year-to-date (YTD) sheets into the dashboard. Ensure that data from these sheets can be easily accessed and analyzed within the dashboard interface. - Menu Navigation: Implement a user-friendly menu system that allows for intuitive navigation throughout the dashboard. - Dynamic Data Population: Enable dynamic data population based on user selections. When a specific month is chosen from the menu, ensure that the dashboard updates to display relevant information for that particular time period. - Summary Numbers: Include a summary section at the top of the dashboard, below the menu, highlighting key financial figures. This should encompass actual budget values, available budget amounts, percentage spent,...
...legal advice on UAE laws and contracts in both Arabic and English. The goal is to create a smart, talk-worthy website that stands out and attracts attention for its intelligence and functionality. Project Requirements: 1. Design and Layout: - Clean, professional, and modern design. - User-friendly and easy navigation. - Mobile-responsive layout. - Incorporate elements that reflect the law firm's branding (colors, logo, etc.). - Ensure the website looks unique and innovative, with a focus on simplicity and smart design. 2. ChatGPT Integration: - Integrate ChatGPT to provide basic legal advice and answers to common questions about UAE laws and contracts. - The ChatGPT should be accessible directly from the homepage. - Ensure that ChatGPT can communicate in both Arabic...
...Add option in back end for users to add products to the sales page and show percentage off - Add option to contact via whatsapp - Add fuction to filter products by price, location, furniture type, new or used - Add super admin user who can add products and add phone numbers. The idea for this one is that in the beginning furniture stores are unlikely to list their products, therefore I plan to go round town get their products and add them to the website. In such cases, I should be able to add the phone number of the specific store. Required fields for when uploading furniture - Furniture condition, new or used - Location - Furniture type - Title (eg 3 seater sofa for sale) - Description - Price - Upload images Product Display: - I envision the p...
...commercial construction projects. The tool should be capable of accurately calculating costs related to materials, labor, and profit margins. **Key Features:** 1. **Material Cost Estimation:** - Database of construction materials with current pricing. - Ability to input custom material costs. - Calculation of total material costs based on project specifications. 2. **Labor Cost Estimation:** - Standard labor rates for various construction tasks. - Option to customize labor rates. - Calculation of total labor costs based on project duration and complexity. 3. **Profit Margin Calculation:** - Input desired profit margin percentage. - Automatic calculation of profit based on material and labor costs. - Summary of...
As a B2B business looking to pitch to small businesses, large corporations, and startups, I need help creating a persuasive pitch slide deck. The pitch slide deck is meant to present a unique value proposition - how we enable businesses to enter the market faster, with less risk and at a lower cost. In addition, I require assistance in creating a cogent Marketing Plan and Growth Strategy. Ideal candidates should have successful experience in: - Developing high-impact pitch decks for B2B service businesses - Designing comprehensive Marketing Plans and Growth Strategies - Crafting unique value propositions focused on cost reduction, improved efficiency, and fast, low-risk market entry Your experience will help turn this "story line" into ...
My company is in need of a dedicated digital marketing expert to drive our online presence and enhance brand recognition. The scope of the project comprises: - Social Media Management: The candidate should be experienced in creating engaging content across various platforms, fostering a strong relationship with our followers, and ultimately driving traffic to our website. - SEO Optimization: The ideal candidate must be capable of developing an SEO strategy that boosts our search engine rankings, increases organic traffic, and boosts our website's visibility. - Email Marketing: The candidate should also have a solid understanding of email marketing best practices. They must be able to create compelling campaigns that target local, national, a...
I'm looking to revamp a website to cater to people with debt concerns, making it more user-friendly and visually appealing. One of the primary objectives of this redesign is to increase leads from the target audience. I would like a wireframe sample of the landing pages before proceeding with the design. Written content will be provided. We would like to create landing pages that provide valuable information about different kinds of debt and debt solutions. There will be approximately 25 landing pages. We will want to include a Blog as well. The website will be in Wordpress. Hosting is already in place. The work will need to be done on a stage site so that the existing site will not be affected. We will switch when the new site is complete...
...looking for an experienced sales and marketing professional who can help us with lead generation in the technology sector, specifically targeting businesses (B2B). Key Responsibilities: - Generate quality leads within the technology industry - Implement effective strategies to engage and convert B2B prospects into clients - Develop a strong understanding of our product to effectively communicate its value to potential clients Ideal Candidate: - Proven track record in tech sales and lead generation - Excellent communication and negotiation skills - In-depth knowledge of B2B sales strategies - Familiarity with the technology sector is a plus This is a great opportunity to work with a dynamic team in a fast-paced industry. If you have th...
I'm looking for someone who can edit videos for me. If you can also plan for videos, tha...you can also plan for videos, that'd be great, but for now I am looking for someone to edit videos. Here are example of videos that I like the styles of: Looking for someone who can preferrably speak different languages like Spanish and Chinese. Also I am not looking to spend a large amount of money in the beginning, something per video or a reasonable amount is what I am looking for - so if your charges are higher than the market value, respectfully save your time.
I'm in need of a talented web developer who can create an engaging, easy-to-use business promotion website, primarily intended for senior citizens. Key Project Specifications: - The website must be aesthetically pleasing and straightforward to navigate, particularly for senior citizens. Simplicity and usability are paramount. - The website will primarily showcase images and text. Creativity and an eye for design are important in balancing the two. - This isn't an ecommerce site. The focus is on presenting the business and its value to seniors in an appealing and compelling manner. Qualified freelancers will have: - Proven experience in creating visually pleasing and user-friendly websites. - Knowledge of the best web design pra...
...pyrolysis oil in Vietnam. The oil is top quality, with high calorific value, low sulfur content, and specially optimized for use in industrial boilers. Key Responsibilities: - Identify and approach potential industrial and commercial buyers in Vietnam. - Promote the benefits and unique selling points of my pyrolysis oil. - Negotiate deals with interested parties. - Secure orders of a minimum of over 5,000 liters per transaction. Ideal Candidate: - A sales professional with experience in the oil or related industry. - An understanding of the industrial and commercial markets in Vietnam. - Proven track record of successful negotiations and deal closures. - Ability to effectively communicate the technical specif...
I'm looking for an experienced graphic designer to create vi...marketable product packaging for my venture. The design will be integral for attracting customers and increasing the product's perceived value. Key Responsibilities: - Designing product packaging that aligns with my brand and target demographic - Ensuring the design is not only visually appealing but also functional and effective Skills and Experience: - Proven experience in graphic design, specifically in product packaging - A good understanding of market trends and consumer preferences - Proficiency in relevant design software to bring the concept to life - Strong communication skills to understand and implement my vision Please note that while experience in social media ...
