[GIS] How to import CSV layer to QGIS using PyQGIS in Windows

csvpyqgisqgis

I'm using QGIS 2.18.14 Las Palmas on Windows 8.1
I tried to import CSV layer to QGIS using this script:

uri = 'file://D:/26mei.csv?d?delimiter=%s&xField=%s&yField=%s' % (",", "Lon", "Lat")
layer_csv = QgsVectorLayer(uri, 'paramHilal', 'delimitedtext')
QgsMapLayerRegistry.instance().addMapLayer(layer_csv)

The last line is to add the CSV layer to layer panel in QGIS, but it didn't appear. It could be because the layer is not valid.
I knew because I have tried layer_csv.isValid() and it return False. But I don't know where my mistake is.
Does anyone knows why my script is not work?

PS: I have tried this on QGIS 2.8 Wien on Ubuntu 16.04 and it worked just fine.

Best Answer

Just a tip according to this: Use PyQGIS to import CSV and draw points using different color

use /// instead // after file.

Related Solutions

[GIS] Understanding QGIS errors when importing .csv file

I found the solution for my problem. There were (probably) two "errors" in my .csv.

QGIS seems to detect that my data field called "text" contained exactly this - a text. Thus, it encoded it as a String (or character) data type. Within such a data field, however, double quotation marks are only allowed at beginning and end or not at all. Since my Tweets contained quotes within them, this seemed to cause the problem. Single quotation marks (the apostrophe) are no a problem (so I just converted them and since then it works). On the other hand, it does not make a difference whether the whole field is contained within quotation marks or not.
QGIS treats a sequence of characters that you enters as "custom delimiters" like a logical or, not and. Thus, when I used "$%&" as delimiters, it also split the record at a single "&". So my choice of delimiters also caused a problem. But I got the idea to use and alt-key character (pressing alt-key and a letter at the same time) as a delimiter from Branco's answer here. I used alt-key plus s and QGIS import the file without any problems.

Also, for the record and in case other German speaking users run into the same error: "Ungültiges Satzformat" translates into "invalid record format" which gets you on the right track while searching for a solution to this error. I ultimately got the idea that the problem has something to do with strings and quotation marks from the comments to this question.

qgis – Adding CSV Layer in PyQGIS for Point Creation

The problem was with your URI. (note the third slash)

Use the following as a working example:

uri = 'file:///D:/Saved Stuff/gulags/1.40.csv?delimiter=;&yField=y&xField=x'
layer = QgsVectorLayer(uri, '1.40', 'delimitedtext')

Best Answer

Related Solutions

[GIS] Understanding QGIS errors when importing .csv file

qgis – Adding CSV Layer in PyQGIS for Point Creation

Related Question