Stack Overflow
Stack Overflow

Questions tagged [describe]

psych library function - used primarily to scale construction and for item analysis using classic psychometrics

Part of the psych library. Used primarily for scale construction and item analysis using classic psychometrics - meaning it displays the most frequently requested stats in psychometric and psychology studies.

Also used with its range flag to check for early coding errors in various analytic and statistical programs.

126 questions
44
votes
1 answer

describe vs context in rspec. Differences?

I've read a little bit about how one should organize rspec code. It seems like "context" is used more for states of objects. In your words, how would you describe how to use "describe" in rspec code? Here is a snippet of my movie_spec.rb…
Jwan622
  • 11,015
  • 21
  • 88
  • 181
26
votes
5 answers

Equivalent of "describe table" in PgAdmin3

Question asked and answered: As many of us know, PostgreSQL does not support describe table or describe view. As one might find from google, PostgreSQL uses \d+ instead. However, if one accesses PostgreSQL using PgAdmin (I am actually using…
user3112568
  • 271
  • 1
  • 3
  • 3
24
votes
2 answers

Can DESCRIBE syntax be embedded in SELECT statement?

In MySQL, the syntax DESCRIBE can show a table's structure, but it cannot be embedded to normal statement; is there some tricky way to do it? For example, this shows the table1 structure, returned as a table (but SQL statement does not think…
JimZ
  • 1,182
  • 1
  • 13
  • 30
22
votes
5 answers

Python Dataframes: Describing a single column

Is there a way I can apply df.describe() to just an isolated column in a DataFrame. For example if I have several columns and I use df.describe() - it returns and describes all the columns. From research, I understand I can add the following: "A…
Gitliong
  • 307
  • 1
  • 3
  • 7
16
votes
2 answers

Pandas Dataframe groupby describe 8x ~slower than computing separatly

The following code summarizes numeric data using two different approaches. The first approach uses the Dataframe().describe() and passes some specific extra percentiles. The second approach separately computes the summary stats (mean, std, N),…
Randall Goodwin
  • 1,916
  • 2
  • 18
  • 34
15
votes
3 answers

What is the cleanest way to sort "describe table" query results?

I'm working on "describe table" output to show a list of fields and their types, i want my primary keys to be at top of the list.. I think there's no way to sort describe's results using SQL (something like 'order by') rather than sorting it in…
Youssef
  • 1,310
  • 1
  • 14
  • 24
13
votes
3 answers

How to describe columns as categorical values?

I have a pandas dataframe that contains a mix of categorical and numeric columns. By default, df.describe() returns only a summary of the numerical data (describing those columns with count, mean, std, min, quantiles, max) when iterating through all…
Zahra
  • 6,798
  • 9
  • 51
  • 76
10
votes
1 answer

Explain Vs Desc anomalies in mysql

What are the differences between EXPLAIN and DESC commands in MySQL ?
Puru
  • 8,913
  • 26
  • 70
  • 91
9
votes
3 answers

Pandas python .describe() formatting/output

I am trying to get the .describe() function to output in a reformatted way. Here is the csv data (testProp.csv) 'name','prop' A,1 A,2 B, 4 A, 3 B, 5 B, 2 when I type in the following: from pandas import * data = read_csv('testProp.csv') temp…
Mike
  • 227
  • 1
  • 3
  • 17
7
votes
1 answer

typescript mocha describe is not a function

The issue I have is that mocha-typescript keeps throwing an error that describe is not defined. TypeError: mocha_typescript_1.describe is not a function at DatabaseTest.WrongPath (test/database_test.ts:21:9) at Context.…
User1
  • 321
  • 3
  • 9
5
votes
3 answers

Describing the schema of a query result in Oracle?

Is it possible to get results similar to the Oracle DESCRIBE command for a query? E.g. I have a join among several tables with a restriction of the columns that are returned, and I want to write that to a file. I later want to restore that value…
Christopher
  • 633
  • 2
  • 7
  • 19
4
votes
1 answer

How pandas describe() - top works when multiple elements have highest count?

Context: I am trying to understand how top attribute of describe() works in python (3.7.3) pandas (0.24.2). Efforts hitherto: I looked into documentation of pandas.DataFrame.describe. It states that: If multiple object values have the highest…
Sha
  • 483
  • 4
  • 8
4
votes
3 answers

std() groupby Pandas issue

Could this be a bug? When I used describe() or std() for a groupby object, I get different answers import pandas as pd import numpy as np import random as rnd df = pd.DataFrame({'A' : ['foo', 'bar', 'foo', 'bar', ...: …
OzgunBu
  • 53
  • 3
4
votes
1 answer

using union in a construct sparql query

I have an rdf graph with several entries. Now I want to get all related triples to a given id. This is my sparql query: select ?s ?p ?o from where { {…
simon
  • 39
  • 1
  • 2
  • 8
4
votes
4 answers

SHOW COLUMNS from multiple tables

I am trying to get the column names from 2 tables. I tried a query like: (SHOW COLUMNS FROM users) UNION (SHOW COLUMNS FROM posts) but that does not work & returns a syntax error. I tried the same query using DESCRIBE but that did not work either.…
randomphp
  • 233
  • 2
  • 4
  • 14
1
2 3
…
8 9