When I read my csv file below

"Data Source","World Development Indicators",

"Last Updated Date","2017-02-01",

"Country Name","Country Code","Indicator Name","Indicator Code","1960","1961","1962","1963","1964","1965","1966","1967",...
Actual data...

enter image description here

"_1" is added to "1960","1961",...

Why does it happen and how can I avoid it?

My environment is Ubuntu 14.04 and QGIS 2.18.1

  • 7
    Neither "1960" nor "1960_1" is a legal SQL identifier (they would need to start with an alpha [a-z]), but "1960_1" is at least a string.
    – Vince
    Feb 19, 2017 at 21:08
  • 1
    using column names that start with a number will cause problems later if you try to style the layer using those columns,
    – Ian Turton
    Feb 20, 2017 at 9:03
  • Ok, so it's related to SQL and to make is explicitly string, it automatically add "_1". I don't know much about SQL but it seems like I should change column names before importing to QGIS. Thank you for the comments!
    – user26767
    Feb 26, 2017 at 17:49


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.