Stack Overflow
Stack Overflow

Questions tagged [tabulate]

Count or tally of named items in an object or structure.

Various languages will have different functions for this operation. "table" or "crosstabs" are two such examples. The output may be multi-dimensional.

168 questions
0
votes
1 answer

Group rows in PROC TABULATE

I have the following (fake) crime data of offenders: /* Some fake-data */ DATA offenders; INPUT id :$12. crime :4. offenderSex :$1. count :3.; INFORMAT id $12.; INFILE DATALINES…
D. Studer
  • 1,711
  • 1
  • 16
  • 35
0
votes
0 answers

Display data fetched from database in python more beautifully?

Function in database con=sqlite3.connect("customer.db") cur = con.cursor() cur.execute("SELECT * FROM customer") row = cur.fetchall() con.close() return row Display customerlist =…
Rishabh Nigam
  • 3
  • 3
0
votes
1 answer

MATLAB - How to prevent tabulate function returning frequencies of variables that are not present in the vector?

I have the vector v1, with 26 elements, either being 'Live' or 'Non-live'. When I use tabulate(v1), it returns tabulate(v1) Value Count Percent cat1 0 0.00% cat2 0 0.00% Live 5 …
supun manathunga
  • 19
  • 3
0
votes
2 answers

How to construct data frame from Web Scraping in Python

I can fetch data from web page thru web scraping in Python. My data is fetched into a list. But don't know how to transform that list into a data frame. Is there any way I could web scrape and fetch data directly to a df? Here is my code: import…
Jamil Rahman
  • 345
  • 1
  • 6
  • 18
0
votes
0 answers

How to solve ModuleNotFoundError (python3 tabulate module) when tabulate module is already installed?

A simple command-line game (game 2048) was written in python3 by my friend, and I cannot run it because I have the following error message: File "c:/Python/2048.py", line 2, in from tabulate import tabulate ModuleNotFoundError: No…
szylwy
  • 1
  • 2
0
votes
0 answers

Dataframe table in email body should be colored based on the condition in dataframe

****I want to highlight the row(out of sync) with red color so that my team can act on out of sync issues upon watching the email immediately. Can someone help here.**** Here is my code def bibreport(): finaldatabib = [] data={} if some…
Deep
  • 1
0
votes
2 answers

Python tabulate: how to achieve auto lining in tabulate?

from tabulate import tabulate table_header = ['Options', 'Explain','Impact'] table_data = [] for i in self.add_list: table_data.append( (somethingtoprint) ) pfile.write(tabulate(table_data, headers=table_header, tablefmt='grid')) Here , when…
shenmufeng
  • 67
  • 1
  • 7
0
votes
3 answers

What is the best way to count values within columns to create a summary table?

I have a tbl_df that has several columns that have multiple values in them. I am looking to use the values in the columns to create several columns. After that, I'm looking to summarize the columns. One way I can go about it is to create several…
Jazzmatazz
  • 615
  • 7
  • 18
0
votes
1 answer

How do I tabulate a variable in Stata to show all values that are in my sample, even if they're not yet in the dataset?

I am trying to tabulate a variable for a report at work to show the completion rate by municipality of a survey that is currently in the field. A dataset is downloaded each week showing all the responses so far, and I need to generate a table that…
Reed Merrill
  • 117
  • 1
  • 10
0
votes
1 answer

Trouble importing Tabulate with Python 3.7

I'm running Python 3.7 on Windows 10 and I keep getting No module named 'tabulate' error. I have deleted Python 2. I've tried everything suggested in a similar question: >> pip install tabulate >> pip3 install tabulate >> python -m pip install…
elena
  • 91
  • 2
  • 12
0
votes
0 answers

How to make PROC TABULATE count the ID numbers, instead of listing each ID accross columns

I want to count the number of provider id numbers (CLM_RNDRG_PRVDR_NPI_NUM) that are associated with each level for HCPCS and SPECIALTY CODE. However, my output displays each provider ID (001 TO 020) across columns. After the "Allowed Units"…
nhandy
  • 73
  • 7
0
votes
1 answer

Pretty print data in tkinter Label

I have following sample data data=[(1,'JohnCena','Peter',24,74), (2,'James','Peter',24,70), (3,'Cena','Peter',14,64), (14,'John','Mars',34,174)] I want to print it on python gui in a beutiful tabular way on tkinter output window.…
Talha Anwar
  • 2,699
  • 4
  • 23
  • 62
0
votes
1 answer

SAS proc Tabulate, Order by specific variable

I am using ficticious numbers as I cannot publish the original dataset. I have the following SAS-Code: PROC TABULATE DATA=table; TITLE 'Offences per country and year; CLASS year country offence_type; TABLES country, year ALL, region /BOX=""…
D. Studer
  • 1,711
  • 1
  • 16
  • 35
0
votes
2 answers

How display Chinese characters properly in tabulate

I use the tabulate to display some data which has Chinese characters. However the output isn't organized. from tabulate import tabulate data = [ ["北京理工大学", "985", 2000], ["清华大学", "985", 3000], ["大连理工大学", "985", 4000], …
Ashechol
  • 38
  • 5
0
votes
0 answers

Posting embedded output using tabulate and Discord Rewrite

I have a Discord bot where I'm attempting to send some output in an embed using the tabulate library. When I send the message using ``` it's formatted as such If I send the message embedded with ``` If I send the message embedded without the…
Josh
  • 164
  • 4
  • 16
1 2 3
…
11 12