I have a crosstab function that I've used successfully many times in the past, but now it's dumping all the data at the end instead of pivoting it into the output table. It can't seem to find Cross...

I have a sample table named antest as shown below to test the crosstab function. create table antest(student text, subject text, result numeric); insert into antest(student, subject, result) value...

Is there a better way to create a contingency table in pandas with pd.crosstab() or pd.pivot_table() to generate counts and percentages. Current solution cat=['A','B','B','A','B','B','A','A','B'...

I have a dataset that looks something like this: I'd like to aggregate all co values on one row, so the final result looks something like: Seems pretty easy, right? Just write a query using c...

I have a pyspark dataframe as follows in the picture: I.e. i have four columns: year, word, count, frequency. The year is from 2000 to 2015. I could like to have some operation on the (pyspar...

I'm using Python 3.4.1 with numpy 0.10.1 and pandas 0.17.0. I have a large dataframe that lists species and gender of individual animals. It's a real-world dataset and there are, inevitably, missin...

I have a view that produces the following resultset: CREATE TABLE foo AS SELECT client_id, asset_type, current_value, future_value FROM ( VALUES ( 1, 0, 10 , 20 ), ( 1, 1, 5 , 10 ), ( 1, 2, 7...

I was wondering if there a way, in a SELECT statement on Postgres, to alias a column with the value of another column in the same data set. Given this table: id key value 1 a d 2 a e 3 ...

I would like to count the number of all possible pairwise relations through a column (Value) based on another column (ID). Example dataframe: ID Value 0 1 A 1 1 A 2 1 A 3 1 B 4 1 C 5 2 B 6 2 C 7 2...

I have a table named as Product: create table product ( ProductNumber varchar(10), ProductName varchar(10), SalesQuantity int, Salescountry varchar(10) ); Sample values: insert into produc...

I want my query result to look like this: Person1 Person2 Person3 Person4 Total Status1 2 4 7 3 16 Status2 0 1 0 3 4 Status3 0 0 0 0 0 Status4 0 1 3 0 4 Total 2 6 10 6 24 I'm able to get every...

I have a table like this INPUT id author size file_ext -------------------------------- 1 a 13661 python 1 a 13513 cpp 1 a 1211 non-code 2 b 1019 python 2 b 6881 cpp 2 b 1525 python 2 b 1208 non-...

I am a beginner with pandas at best and I couldn't find a solution to this problem anywhere. Let's say I have two variables: variable1, variable2. They can have the following predefined values: ...

I've been doing a bit of research on this topic and I can't seem either find a workable solution, or one that is explained well enough for me to implement. If you've ever created a crosstab query ...

I am trying to create a crosstab table that will have rows = months and columns = days (ie 1, 2, 3, 4...31). Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 ... ------+------+------+---...

I create a large query as a Common Table Expression - month_index using WITH clause. Is it possible to refer this Common Table Expression in a crosstab query's source sql? When I did gets an erro...

I have a dictionary comprised of product names and unique customer emails who have purchased those items that looks like this: customer_emails = { 'Backpack':['[email protected]','[email&#160...

In SPSS, it is (relatively) easy to create a cross tab with multiple variables using the factors (or values) as the table heading. So, something like the following (made up data, etc.). Q1, Q2, and...

I'm trying to write a script that copies data from a crosstab query to a .csv file in Postgres 8.4. I am able to run the command in the psql command line but when I put the command in a file and ru...

Postgres 9.2.1 on OSX 10.9.2. If I run the following crosstab example query: CREATE EXTENSION tablefunc; CREATE TABLE ct(id SERIAL, rowid TEXT, attribute TEXT, value TEXT); INSERT INTO ct(rowid...

I have a data source that is composed of object { groupName, rowName, colName, value }. I'm trying to put the fields row,col,val in a crosstab, separated by group [the group has headers]. A collect...

I try to get result from this query $sql = " SET @col = NULL; SET @sql = NULL; Select Group_Concat(Distinct Concat( 'SUM(CASE WHEN tbl.sdate = ''', colname, ''' THEN tbl.result ELSE NULL ...

I have seen that there are quit a few similar questions like this one, but I havent understood how to code it myself. Please have in mind that I am just a beginner in this field. Basically I want ...

I implemented this function in my Postgres database: http://www.cureffi.org/2013/03/19/automatically-creating-pivot-table-column-names-in-postgresql/ Here's the function: create or replace functi...

I'm trying to sort my dynamic columns in a cross tab according to some custom scheme. In the docs I found mention of comparatorExpression: Crosstab group bucket comparator expression. The result ...