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
1
vote
0 answers

How to tabulate Conditional Frequency Distribution for collocations in texts

I have several texts that I found collocations for, and now I'd like to create a table that shows how many times each collocation appears in each text of the corpus. When I generate a table or a plot from the ConditionalFreqDist,it shows only 1…
Gavrk
  • 295
  • 1
  • 4
  • 16
1
vote
2 answers

SAS: ODS EXCEL (how to name different sheets)

I want to export a table generated by PROC TABULATE. My code goes like this: ODS EXCEL FILE="myFile.xlsx" (options sheet_name="CRIME TYPE"); PROC TABULATE DATA=myData; TITLE 'myTitle'; BY crime_type; CLASS year; CLASS nation /…
D. Studer
  • 1,711
  • 1
  • 16
  • 35
1
vote
2 answers

Python tabulate - configure how to format cells containing lists

I'm using python-tabulate to print data having cells containing lists. Can I customize how python-tabulate formats cell contents, so lists are formatted in a different way? I would like to avoid having to manually pre-process (convert the lists to…
Wolkenarchitekt
  • 20,170
  • 29
  • 111
  • 174
1
vote
5 answers

Tabulate coefficients from lm

I have 10 linear models where I only need some information, namely: r-squared, p-value, coefficients of slope and intercept. I managed to extract these values (via ridiculously repeating the code). Now, I need to tabulate these values (Info in the…
Candice
  • 67
  • 7
1
vote
2 answers

Python tabulate: how to print specific cell content?

I have this code: from tabulate import tabulate import pandas …
user10370401
0
votes
1 answer

Colorama not working with Tabulate to display colored output in Python

I am attempting to create a colorful table in Python using the tabulate and colorama libraries. However, despite having both libraries installed and confirmed that colorama works fine with other programs, the output is not colored as…
0
votes
2 answers

to_markdown doesn't pass intfmt to tabulate

Comma separation seems to work fine without a Pandas DataFrame. Executing from tabulate import tabulate print(tabulate([['2023m06',2000],['2023m05',100000]], tablefmt='rounded_grid', intfmt=',')) gives…
aeroNotAuto
  • 260
  • 3
  • 13
0
votes
0 answers

Unable to display data in table using tabulate

I wrote the following code to extract commit information from a GitHub repos. I've used the tabulate module to display the data in tabular form. I'm getting UnicodeEncodeError: 'charmap' codec can't encode characters in position 0-5346: character…
0
votes
1 answer

tabulate formated pandas df sending by outlook email

I'm working on an automated email sender script. My goal is to send 2 tables by email each and every time my results are generated. So far I tried the tabulate python package, which looks really nice if I print it in the console of PyCharm, but when…
pahi
  • 95
  • 5
0
votes
0 answers

Printing arbitrary number of columns with tabulated-list-print

I have the following function that displays a table in a buffer. But this handles only two columns. How can I extend this to handle an arbitrary number of columns? (defun tlprint-alist (alist &optional outbufr keytl valtl) "Print an associated…
Dilna
  • 405
  • 1
  • 6
0
votes
1 answer

SAS Proc Tabulate, column for SUM total instead of COUNT

using the SAS help data prdsale as an example, I would like a single table showing the SUM of predicted and actual sales for each country/region. I'm happy with the final table, except I can't get a total column that sums the value of both types of…
Sproodle
  • 25
  • 4
0
votes
0 answers

Need to export a table that has multiple tables in it to excel in R

Here is my code to create the table(s) tt <- xtabs( ~ Support + Service.Affiliation + Report.Type + Referral, data = flatcut1) ty <- addmargins(tt) This makes nine tables that I can see in the console and looks great. My problem is I…
0
votes
1 answer

Having a problem running python script from import error of modules that i have installed on my computer

i have ran pip install tabulate (other Modules too) however when running script it says i am missing such modules import error of the various modules as you can see it says that I have an issue even when i have tabulate installed. evidence that i…
0
votes
1 answer

Sorting a collaborative database

I'm working through a database with several repeated IDs entries and unique information per row as such ID country A1 AT A1 BE A2 CZ A3 US A3 UK A4 NZ The same ID and different country implies there was collaboration between…
bcast
  • 3
  • 1
0
votes
0 answers

How do I auto tabulate the Column in B and C once I copy a Number that has been appeared before?

How do I auto tabulate the Column in B and C once I copy a Number that has been appeared previously? =if(countif($A:$A,A6)>1, VLOOKUP(A6,$A:$B,2,False),"") I tried using this but not all the time it works. some fields cannot publish. I have aligned…
Ben Au
  • 1