Stack Overflow
Stack Overflow

Questions tagged [percentage]

Percentage is a ratio or fraction of a quantity that shows the ratio from whole part of quantity. Percentage demonstrates how much is there out of 100.

The ratio or fraction from a quantity that consider out of 100 is called Percentage.

The Percentage is calculate by following formula:

percentage = (part of quantity * 100)/total quantity
2714 questions
0
votes
1 answer

how to add percentage sign on bars in GGplot2

I searched SO quite a long time, but no hint helped me, so i am gonna ask seperately. I am a beginner in R and wrote following code: matchplayerNew <- match_player %>% group_by(civ, group = winner) %>% summarize(count = n()) %>% # count records…
Mäsä
  • 3
  • 3
0
votes
1 answer

Determine percentage of variance of samples for each component in R

I applied PCA to my biomedical data (31 genes~rows and 1904 patients~columns) with a selection of 9 components. As a result, I have two sub-matrices in which one is a 9 by 1904 matrix (I call it matrix A). Matrix A presents its rows are 9…
Huy Nguyen
  • 61
  • 5
0
votes
1 answer

matching percentage with mysql

I have been trying to create an algorithm with MySQL that returns a list of users that matches an offer and the percentage of the matching. If the users matches the basic main criteria of the offer, they got 70% as a start then if they match some…
fatim
  • 5
  • 3
0
votes
0 answers

Convert a count in which 'partition by' is used to percentage with decimal places in SQL Server?

I would like to convert a COUNT which includes PARTITION BY in SQL Server. Desired output would be percentage to 2 decimal places with '%' symbol included (78.48% instead of 78, for example). Here is what I have: (((100 * COUNT(STC_GRADE)) /…
KLR
  • 51
  • 7
0
votes
1 answer

Ratio of [value in cell to the left] to [sum of values above cell to the left] into a new column using pandas

I have a column called Bets of poker bets in a dataframe called ACTION_DATA. I want to create a new column with the Bet-to-Pot Ratio (% of Pot) Bet-to-Pot Ratio equals the bet in the same row from the Bets column divided by the sum of all previous…
Ricardo Barrios
  • 29
  • 9
0
votes
1 answer

How can I define a transition making the content appear from outside the screen in MotionLayout?

I am using MotionLayout and I want to make the content appear sliding from the bottom of the screen. I want to use translationY but I cannot define %. I have to define dp. Is there a way to achieve it writing it in a ?
Marti Serra Molina
  • 423
  • 3
  • 11
0
votes
1 answer

How to calculate percentage increase between rows in Oracle SQL?

I have data like: YEAR_MONTH|AVG_VISITS|WAS_MEMBER 2020-09|10|True 2020-09|5|False 2019-04|2.5|True 2019-04|5|False I'd like to make it into a table that calculates the percentage of visits membership…
Mark McGown
  • 975
  • 1
  • 10
  • 26
0
votes
2 answers

Plot category, proportion, total

I am trying to make bar plot in python using name, prop, total. The idea is I should have name and then if I can show total streams and what proportion are male. I have following example data NAME prop_male total GGD 0.254147 …
James Taylor
  • 484
  • 1
  • 8
  • 23
0
votes
2 answers

compute percentage reduction based on a year

I have this dataframe: dat = read.delim(text = "LM, year 85.20000, 2020 56.70000, 2021 49.00000, 2022 71.00000, 2023 33.00000, 2024 96.50000, 2025 26.30000, 2026 21.30000, 2027", sep = ",", header = T) I want to calculate the…
minoo
  • 555
  • 5
  • 20
0
votes
2 answers

How can I calculate the percentage of given binary variables between groups in a dataframe

I have a dataframe with multiple person answering multiple questions. Questions are operationalized as 1=agree and 0=not agree. The same person has answered multiple question and now I want to find out the percentage of agree statement, hence 1,…
Luke
  • 21
  • 5
0
votes
1 answer

Calculate percentage of subqueries from the same table with group by and having clauses

I'm using PostGres 10.12 DB which contains various fields about tests: |test_name|result |report_time|main_version|environment| | A |error |29/11/2020 | 1 | john | | A |failure|28/12/2020 | 1 | john | | A …
ocp1000
  • 571
  • 1
  • 5
  • 12
0
votes
1 answer

Pandas dataframe cell divided by subtotals

I have a dataframe which looks like this: My end goal is to calculate the percent of each purpose and for each origin So the final table should look this: Any assistance or direction will be greatly appreciated
Py_junior
  • 93
  • 1
  • 10
0
votes
1 answer

how to get percentage of columns to sum of row in python

I have a very high dimensional data with more than 100 columns. As an example, I am sharing the simplified version of it given as a below: date product price amount 11/17/2019 A 10 20 11/24/2019 A 10 20 12/22/2020 A 20 30 15/12/2019…
user3104352
  • 1,100
  • 1
  • 16
  • 34
0
votes
1 answer

percentage calculation in my function is not working

so what I am trying to do is take a vector of numbers, find the number of time each element occurs then calculate the percentage equivalent of its number of occurances in the vector. it works perfectly well on a vector with a few elements of only…
Yugenswitch
  • 125
  • 2
  • 5
0
votes
1 answer

proportions in sql

I am trying to calculate a proportion of a portion to a total. My table looks like this: State City Money_Awarded NY NYC 5 NY QBC 7 NJ NJC 8 NJ ABC 6 I have written a query that gives me totals per state (using SUM and GROUP BY…
Willy_Golden
  • 51
  • 1
  • 7
1 2 3
…
99 100