Questions tagged [frequency-table]

38 questions
0
votes
0 answers

Frequency table that includes zero counts but only for variable combinations that exist within my data frame

Hello I am new to this forum and relatively new to coding in R. I am having problems building a frequency table that fills in counts of zeros when some of my variables are linked. My test data consists of vegetation counts of 3 vegetation genera, in…
0
votes
0 answers

Remove Duplicate Values from List in R entirely

In contrast to the other requests that want unique values of the whole list, the intention of the request is to remove all the values that appear more than one time AND not keep them remaining. #create a list in R: f <-…
0
votes
1 answer

Creating Frequency Table from Likert Scale data in R

A seemingly straightforward task has proven to be really difficult in R. I'm working with survey data containing propositions asking respondents to indicate their level of agreement or disagreement on a 7-point Likert Scale. I'm trying to create…
Sahana
  • 3
  • 1
0
votes
0 answers

Trying to have python function return frequency table

opened_file = open(r'C:\Users\lalus\Desktop\Datasets\cars.csv') from csv import reader read_file = reader(opened_file) cars_data = list(read_file) def howMany(index): a_list = {} for row in cars_data[1:]: if row[index] in a_list: …
0
votes
1 answer

How do i turn my frequency table into a dataframe to make a bar chart graph?

I think that the title doesn't really help, but... let's go. I have data about a candidates tweets. Its a dataframe and one of the columns its named "Tweets" (each row I have a different tweet). I've used the following functions to make a frequency…
0
votes
2 answers

Summary function in R does not give frequency table

When I use summary() function in R, it gives me correct output for continuous numerical variables, but it does not give me the frequency tables for character variables. My colleague uses the same code on the same data sets and gets the frequency…
-1
votes
1 answer

Python Frequency Table with Percentages

How would I create a frequency table in Python that looks like the image attached? I want to be able to add a title and include a grand total summary at the bottom. Is there a code for this? Frequency table with count of instances and percentages
-1
votes
2 answers

How to find rows with most values filled in a matrix?

Given a matrix (mat1) like this: mat1 <- matrix(c(1, "", 2, 3, 4, "", 2, 4, "", 5, 2, 1, 4, "", 3, 2, "", 3, "", ""), nrow = 4, ncol = 5) How would I go about finding say the top 3 rows with the most non-empty string values? For example in mat1,…
1 2
3