Questions tagged [pivot-table]
The pivot-table tag has no usage guidance.
7
questions
0
votes
0answers
8 views
How to fix blank “input field” column in pivot table?
I need to us the pivot too, so the GM_Naam field are rows and the BG2015 fields are separate columns containing the Area_Ha values.
But when I look at the resulting table, the GM_Naam field is ...
1
vote
1answer
24 views
pivot-table and group geometries
Postgresql11 - postgis2.4
Here is a table mytbl with points and an attribute var :
geom | var
pt a
pt b
pt1 a
pt1 a
pt1 b
pt2 c
...
I want to "rotate" the table like this :
...
1
vote
0answers
64 views
Creating virtual layer or view table from original table using pivot table on QGIS?
I have a table and I need to produce a virtual layer with pivot or crosstable command.
Is it possible on QGIS 3.6 or 3.8?
My original sql is:
select cd_setor, Name, Path_relativo
from Fotos
order ...
2
votes
1answer
109 views
Flattening multiple fields using Pivot Table in ArcPy? [closed]
I'm trying to flatten a table, but I want to keep/relate certain fields tied to each other. For context, I ran a Generate Near Table to try to find the traffic volumes near intersections.
I am trying ...
5
votes
0answers
380 views
Taking ArcGIS feature class to pandas pivot table? [closed]
I'm new to pandas and am trying to create a pivot table based off of two fields - DIVISION and MATERIAL. I'd like to count each occurances of each value. Rows would be DIVISION and columns would be ...
4
votes
1answer
56 views
Labelling Max coverage by Area
I'm struggling to find a quick way to identify and label an area by the maximum coverage of an overlapping polygon. Has anyone done a process like this lately?
I'm currently playing with the Pivot ...
3
votes
1answer
211 views
Crosstable two fields of pointfile using ArcMap?
I'd like to produce a simple crosstabulation from two fields of a point feature class. These fields contain land use class information which I'd like to compare.
One option is to export a dbf and do ...
