Hot answers tagged

7 votes

Uploading CSV file without coordinates in QGIS

Your data is related to "LSOAs in England and Wales and Data Zones in Scotland." (from the readme) so you need to download some LSOA boundaries (and Data Zones in Scotland). Then you can ...
Ian Turton's user avatar
  • 81k
4 votes
Accepted

Create layer from CSV with a bunch of KML polygons

Convert KML to WKT The following script is jpinilla's answer implemented in PyQGIS. It can be run in the Script Editor of the Python Console. It does the following: Takes your original CSV as the ...
Matt's user avatar
  • 16.2k
3 votes

Merging features with same value in a table (CSV)

Solution using the Group Stats Plugin using the data in the table attached to the question as input data.
pigreco's user avatar
  • 4,435
2 votes

Create layer from CSV with a bunch of KML polygons

QGIS cannot directly interpret KML format within a CSV file, so I suggest you: Convert KML to WKT (Well-Known Text). Update Your CSV to replace the KML columns with the new WKT geometries. Import ...
jpinilla's user avatar
  • 3,230
2 votes

Merging features with same value in a table (CSV)

I add also a simple SQL way, using the great duckdb cli. Running duckdb --csv -c "PIVOT ( SELECT * EXCLUDE (id, Gender) FROM read_csv_auto('input.csv') ) ON Category USING SUM(Amount)&...
aborruso's user avatar
  • 1,259
2 votes

Merging features with same value in a table (CSV)

If the number of Categories are known and not too many (to type in manually in the query), you can create a query layer / virtual layer. Open the DB Manager and execute the query in the Virtual Layers ...
BERA's user avatar
  • 71.2k
1 vote

Merging features with same value in a table (CSV)

You could start from reshape the CSV. If the input is in example this id,Year,Neighbourhood_name,Category,Gender,Amount 1,2019,Emilstorp,0-5 years,Male,15 2,2019,Emilstorp,6-15 years,Female,25 3,2021,...
aborruso's user avatar
  • 1,259
1 vote
Accepted

Converting WGS84 UTM to WGS84 ESPG:2039 in CSV file format

One is gdal. If your input in example is id,easting,northing 1,325000,4256000 2,328000,4150000 you can run ogr2ogr -f "CSV" output.csv input.csv \ -s_srs EPSG:32633 \ -t_srs EPSG:2039 \ -oo ...
aborruso's user avatar
  • 1,259
1 vote

Arranging the CSV file of time series data exported from Google earth engine

You could use a CSV aware cli tool, like the great Miller, to reshape your CSV from long to wide, and run mlr --csv reshape -s ID,Mean input.csv >output.csv to get date P1 P2 P3 year1/month1 xxx ...
aborruso's user avatar
  • 1,259

Only top scored, non community-wiki answers of a minimum length are eligible