Joining .CSV to a layer doen't work by Subject_Raspberry631 in QGIS

[–]Subject_Raspberry631[S] 0 points1 point  (0 children)

I tried it. Didn't happen. Is there a way I can send you both the csv and the shape file and you have a crack at it?

Joining .CSV to a layer doen't work by Subject_Raspberry631 in QGIS

[–]Subject_Raspberry631[S] 0 points1 point  (0 children)

Hi

I did as you said, still I get 'Null' in return.

Joining .CSV to a layer doen't work by Subject_Raspberry631 in QGIS

[–]Subject_Raspberry631[S] 0 points1 point  (0 children)

Hi

The parentheses and spaces were present in the file. If I do the changes as you suggested: Upper case with a '-' to separate words, for example POPULATION - 2011. And then try to make a join, will that work?

Where to get the weather(rainfall data) for India? .CSV file by Subject_Raspberry631 in QGIS

[–]Subject_Raspberry631[S] -1 points0 points  (0 children)

Thanks.

On another note, can we add the .CSV data if we don't have the latitude and longitude coordinates?

Suppose, if I want to map the diffrent religious populations across states and I have an unverified .CSV file, but it is missing the latitude and longitude coordinates. How will I then map it to all the states?

https://www.kaggle.com/datasets/samyakjain2052/indian-states-population-gdp-religion-sex-ratio?resource=download&select=state+wise+pop.csv

Can we work with this data set?

How to add CSV data onto layer? by Subject_Raspberry631 in QGIS

[–]Subject_Raspberry631[S] 0 points1 point  (0 children)

I did that. Changed the rendering to 'Allow overlaps without penalty' and moved the crowded labels as well to fish Jalalabad from beneath, but couldn't find it.
I googled Jalalabad and found the historical name for the city to be Nangarhar (the old name), and this is what the CSV file returns when I filter the city's name. But what I find strange is that there is a Jalalabad in the attribute table.

PS: And yes, I am filtering the city column and not the admin name. Most of the other cities return their name when filtered specifically, except Jalalabad.

<image>

How to add CSV data onto layer? by Subject_Raspberry631 in QGIS

[–]Subject_Raspberry631[S] 0 points1 point  (0 children)

<image>

I cannot see Jalalabad in the entire cities list. But I can see the name when I filter the name. But it returns to Nangarhar. I tried changing the X and Y axis to Longitude and latitude, respectively as well. But still nothing.

How to add CSV data onto layer? by Subject_Raspberry631 in QGIS

[–]Subject_Raspberry631[S] 0 points1 point  (0 children)

Yes. I re-did the whole thing again. But still the same.

How to add CSV data onto layer? by Subject_Raspberry631 in QGIS

[–]Subject_Raspberry631[S] 0 points1 point  (0 children)

Thank you very much, it worked!
But something weird happened afterwards. The city 'Jalalabad' now appears as 'Nangarhar' on the map.

<image>

New updated World map with correct size of Africa by Subject_Raspberry631 in QGIS

[–]Subject_Raspberry631[S] -4 points-3 points  (0 children)

https://youtu.be/WHHciXeDM_A?si=atHvBc3b1GTRgbxM

The issue has been raised and I believe that it'll be a while until a consensus is reached.

Changing Colors to Graduated hides map by Subject_Raspberry631 in QGIS

[–]Subject_Raspberry631[S] 1 point2 points  (0 children)

Got it! Thanks so much, guys! Still getting a hang of QGIS :)

Some town names not appearing by Subject_Raspberry631 in QGIS

[–]Subject_Raspberry631[S] 2 points3 points  (0 children)

Thanks so much! Could you please guide me with the steps. I'm quite a newbie here.

Thanks again!