How to create a GeoDataFrame from Datafram correctly?How can I create a grid of polygons from a .csv file or...

What if you do not believe in the project benefits?

Identical projects by students at two different colleges: still plagiarism?

Sauna: Wood does not feel so hot

How to know if I am a 'Real Developer'

Taking an academic pseudonym?

Almost normal subgroups: Is there any notion which is weaker than normal subgroup?

Is it ethical to apply for a job on someone's behalf?

Is opening a file faster than reading variable content?

How can I make my enemies feel real and make combat more engaging?

How do I handle a blinded enemy which wants to attack someone it's sure is there?

Why is quixotic not Quixotic (a proper adjective)?

Badly designed reimbursement form. What does that say about the company?

Does changing "sa" password require a SQL restart (in mixed mode)?

80-bit collision resistence because of 80-bit x87 registers?

Short story where Earth is given a racist governor who likes species of a certain color

Was the Soviet N1 really capable of sending 9.6 GB/s of telemetry?

How do I add a strong "onion flavor" to the biryani (in restaurant style)?

Exploding Numbers

Manager has noticed coworker's excessive breaks. Should I warn him?

Last Reboot commands don't agree

How to scroll to next div using Javascript?

The Late Queen Gives in to Remorse - Reverse Hangman

How can changes in personality/values of a person who turned into a vampire be explained?

Aligning Systems of Equations

How to create a GeoDataFrame from Datafram correctly?

How can I create a grid of polygons from a .csv file or line vector in qgis?Assign a point to polygon using pandas and shapelyCreate GPS (gpx) routes from GeoPandas geodataframePerforming Spatial Join / match Points from dataframe to polygons using Python?How to convert a GeoSerie to a GeoDataFrame with GeopandasPopulate missing fields/labels for a grid of polygons with python?Cannot find polygons that are inside a big polygon using GeoPandasAssigning an ID to each pixel which overlaps with polygon shapefile (Python)Getting error while importing GeoPandas in Python consoleException raised when saving Geopandas DataFrame into a file

I am new to python and struggling with this problem:

I have a DataFrame which contains one column called 'WKT' with polygons. I wanted to import it by using gdp.read_file. The import is working but when I check the type, I find out it is still a pandas.core.frame.DataFrame.

Here is my code for importing the file:

import pandas as pd

% matplotlib inline

import geopandas as gpd

from shapely.geometry import Point, Polygon



df = gdp.read_file('C:UserslukasOneDriveDokumenteStudiumBachelorBachelorarbeitDatenrichtw2018.shp')

The shapefile has the column called 'WKT' and here an example of one polygon:

POLYGON ((404858.32540000044 5766528.0963,404893.65369999968 5766524.441299999,404916.39379999973 5766530.126,404935.07330000028 5766539.4655,404998.01219999976 5766389.2179,405015.8788 5766348.204299999,405167.56120000035 5766422.8264,405167.75119999982 5766422.9199,405167.75210000016 5766422.9276,405224.7648 5766453.135199999,405315.74610000011 5766500.575099999,405316.94699999969 5766487.1231,405316.94969999976 5766487.3498,405338.79040000029 5766488.1486,405355.5702 5766468.4385,405375.2796 5766430.8827,405378.47350000031 5766279.595799999,405381.77639999986 5766133.8343,405380.52479999978 5766133.8343,405384.2774 5765999.605599999,405428.70760000031 5766005.237,405429.33299999963 5765983.022,405434.96229999978 5765802.486,405425.57550000027 5765789.6577,405392.09509999957 5765697.669399999,405376.5439 5765653.4131,405350.84109999985 5765563.171399999,405239.65770000033 5765587.2338,405208.33889999986 5765588.3267,405024.0681 5765596.341399999,404792.09059999976 5765605.8135,404832.99000000022 5765791.2378,404876.23780000024 5765767.7685,404894.82689999975 5765802.8818,404891.14329999965 5765804.8698,404904.02199999988 5765894.235,404910.426 5766014.272,404915.92499999981 5766117.073,404858.14460000023 5766192.3266,404858.19369999971 5766192.3583,404855.89659999963 5766195.251,404806.3438 5766257.6526,404789.69539999962 5766293.793299999,404788.07139999978 5766308.4119,404753.96250000037 5766391.251,404701.17499999981 5766513.0734,404763.3054 5766589.008199999,404800.66330000013 5766544.3398,404816.5 5766536.2182,404858.32540000044 5766528.0963))

When I checked the file for his type by:

type(df)

type(df['WKT'])

It is still a panda DataFrame and Series.

Can please somebody help me to figure out how to import the shapefile correctly?

Thank you!

asked 3 hours ago

Lukas

New contributor

1

What do you mean exactly with "The shapefile has the column called 'WKT'"? Normally, a shapefile has actual shapes stored separately from the attributes, so there should be no column like that. Are you sure that the file you have is a shapefile?

– joris
2 hours ago

I displayed it with df.head() and there was the column WKT with the different Polygons.

– Lukas
1 hour ago

It might be you have such a column, but an actual shapefile should still have the geometries stored as well. Does the dataframe returned from geopandas.read_file have a 'geometry' column? That should normally be the case.

– joris
1 hour ago

add a comment |

I am new to python and struggling with this problem:

Here is my code for importing the file:

import pandas as pd

% matplotlib inline

import geopandas as gpd

from shapely.geometry import Point, Polygon



df = gdp.read_file('C:UserslukasOneDriveDokumenteStudiumBachelorBachelorarbeitDatenrichtw2018.shp')

The shapefile has the column called 'WKT' and here an example of one polygon:

When I checked the file for his type by:

type(df)

type(df['WKT'])

It is still a panda DataFrame and Series.

Can please somebody help me to figure out how to import the shapefile correctly?

Thank you!

asked 3 hours ago

Lukas

New contributor

1

What do you mean exactly with "The shapefile has the column called 'WKT'"? Normally, a shapefile has actual shapes stored separately from the attributes, so there should be no column like that. Are you sure that the file you have is a shapefile?

– joris
2 hours ago

I displayed it with df.head() and there was the column WKT with the different Polygons.

– Lukas
1 hour ago

It might be you have such a column, but an actual shapefile should still have the geometries stored as well. Does the dataframe returned from geopandas.read_file have a 'geometry' column? That should normally be the case.

– joris
1 hour ago

add a comment |

I am new to python and struggling with this problem:

Here is my code for importing the file:

import pandas as pd

% matplotlib inline

import geopandas as gpd

from shapely.geometry import Point, Polygon



df = gdp.read_file('C:UserslukasOneDriveDokumenteStudiumBachelorBachelorarbeitDatenrichtw2018.shp')

The shapefile has the column called 'WKT' and here an example of one polygon:

When I checked the file for his type by:

type(df)

type(df['WKT'])

It is still a panda DataFrame and Series.

Can please somebody help me to figure out how to import the shapefile correctly?

Thank you!

asked 3 hours ago

Lukas

New contributor

I am new to python and struggling with this problem:

Here is my code for importing the file:

import pandas as pd

% matplotlib inline

import geopandas as gpd

from shapely.geometry import Point, Polygon



df = gdp.read_file('C:UserslukasOneDriveDokumenteStudiumBachelorBachelorarbeitDatenrichtw2018.shp')

The shapefile has the column called 'WKT' and here an example of one polygon:

When I checked the file for his type by:

type(df)

type(df['WKT'])

It is still a panda DataFrame and Series.

Can please somebody help me to figure out how to import the shapefile correctly?

Thank you!

python polygon geopandas geoseries

asked 3 hours ago

Lukas

New contributor

asked 3 hours ago

Lukas

New contributor

asked 3 hours ago

Lukas

New contributor

asked 3 hours ago

Lukas

asked 3 hours ago

Lukas

New contributor

Lukas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

1

What do you mean exactly with "The shapefile has the column called 'WKT'"? Normally, a shapefile has actual shapes stored separately from the attributes, so there should be no column like that. Are you sure that the file you have is a shapefile?

– joris
2 hours ago

I displayed it with df.head() and there was the column WKT with the different Polygons.

– Lukas
1 hour ago

It might be you have such a column, but an actual shapefile should still have the geometries stored as well. Does the dataframe returned from geopandas.read_file have a 'geometry' column? That should normally be the case.

– joris
1 hour ago

add a comment |

1

What do you mean exactly with "The shapefile has the column called 'WKT'"? Normally, a shapefile has actual shapes stored separately from the attributes, so there should be no column like that. Are you sure that the file you have is a shapefile?

– joris
2 hours ago

I displayed it with df.head() and there was the column WKT with the different Polygons.

– Lukas
1 hour ago

It might be you have such a column, but an actual shapefile should still have the geometries stored as well. Does the dataframe returned from geopandas.read_file have a 'geometry' column? That should normally be the case.

– joris
1 hour ago

What do you mean exactly with "The shapefile has the column called 'WKT'"? Normally, a shapefile has actual shapes stored separately from the attributes, so there should be no column like that. Are you sure that the file you have is a shapefile?

– joris
2 hours ago

I displayed it with df.head() and there was the column WKT with the different Polygons.

– Lukas
1 hour ago

It might be you have such a column, but an actual shapefile should still have the geometries stored as well. Does the dataframe returned from geopandas.read_file have a 'geometry' column? That should normally be the case.

– joris
1 hour ago

add a comment |

1 Answer
1

active

oldest

votes

The way you are doing it is the correct way. Maybe the shapefile is corrupt? Try adding r to your path so the backslashes are interpreted correctly:

df = gdp.read_file(r'C:UserslukasOneDriveDokumenteStudiumBachelorBachelorarbeitDatenrichtw2018.shp')

Or you could use the well known text (wkt) column to create a geodataframe from your dataframe:

import pandas as pd

import geopandas as gpd

from shapely import wkt



#Create some test data, skip this step

d = {'col1':[1],'wkt':['POLYGON ((30 10, 40 40, 20 40, 10 20, 30 10))']}

df = pd.DataFrame(data=d)



#Use wkt.loads to return geomety objects

df['wkt'] = df['wkt'].apply(wkt.loads)



#Create geodataframe from dataframe, change epsg code to match your spatial reference

gdf = gpd.GeoDataFrame(df,geometry='wkt',crs={'init':'epsg:3006'})

edited 2 hours ago

answered 2 hours ago

BERA

16.1k52042

Thank you for your response! Unfortunatelly I still couldnt fix the problem. When I am using apply (wkt.loads) , I get the Error Message: string or integer address expected instead of Polygon instance... Can you maybe help out? THX!

– Lukas
2 hours ago

Sounds like your data frame is in fact a geodataframe

– BERA
2 hours ago

1

Okay, I just downloaded the file again and now it is working. Thank you anyway for your help!

– Lukas
1 hour ago

add a comment |

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "79"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

Lukas is a new contributor. Be nice, and check out our Code of Conduct.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f313062%2fhow-to-create-a-geodataframe-from-datafram-correctly%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

The way you are doing it is the correct way. Maybe the shapefile is corrupt? Try adding r to your path so the backslashes are interpreted correctly:

df = gdp.read_file(r'C:UserslukasOneDriveDokumenteStudiumBachelorBachelorarbeitDatenrichtw2018.shp')

Or you could use the well known text (wkt) column to create a geodataframe from your dataframe:

import pandas as pd

import geopandas as gpd

from shapely import wkt



#Create some test data, skip this step

d = {'col1':[1],'wkt':['POLYGON ((30 10, 40 40, 20 40, 10 20, 30 10))']}

df = pd.DataFrame(data=d)



#Use wkt.loads to return geomety objects

df['wkt'] = df['wkt'].apply(wkt.loads)



#Create geodataframe from dataframe, change epsg code to match your spatial reference

gdf = gpd.GeoDataFrame(df,geometry='wkt',crs={'init':'epsg:3006'})

edited 2 hours ago

answered 2 hours ago

BERA

16.1k52042

Thank you for your response! Unfortunatelly I still couldnt fix the problem. When I am using apply (wkt.loads) , I get the Error Message: string or integer address expected instead of Polygon instance... Can you maybe help out? THX!

– Lukas
2 hours ago

Sounds like your data frame is in fact a geodataframe

– BERA
2 hours ago

1

Okay, I just downloaded the file again and now it is working. Thank you anyway for your help!

– Lukas
1 hour ago

add a comment |

The way you are doing it is the correct way. Maybe the shapefile is corrupt? Try adding r to your path so the backslashes are interpreted correctly:

df = gdp.read_file(r'C:UserslukasOneDriveDokumenteStudiumBachelorBachelorarbeitDatenrichtw2018.shp')

Or you could use the well known text (wkt) column to create a geodataframe from your dataframe:

import pandas as pd

import geopandas as gpd

from shapely import wkt



#Create some test data, skip this step

d = {'col1':[1],'wkt':['POLYGON ((30 10, 40 40, 20 40, 10 20, 30 10))']}

df = pd.DataFrame(data=d)



#Use wkt.loads to return geomety objects

df['wkt'] = df['wkt'].apply(wkt.loads)



#Create geodataframe from dataframe, change epsg code to match your spatial reference

gdf = gpd.GeoDataFrame(df,geometry='wkt',crs={'init':'epsg:3006'})

edited 2 hours ago

answered 2 hours ago

BERA

16.1k52042

Thank you for your response! Unfortunatelly I still couldnt fix the problem. When I am using apply (wkt.loads) , I get the Error Message: string or integer address expected instead of Polygon instance... Can you maybe help out? THX!

– Lukas
2 hours ago

Sounds like your data frame is in fact a geodataframe

– BERA
2 hours ago

1

Okay, I just downloaded the file again and now it is working. Thank you anyway for your help!

– Lukas
1 hour ago

add a comment |

The way you are doing it is the correct way. Maybe the shapefile is corrupt? Try adding r to your path so the backslashes are interpreted correctly:

df = gdp.read_file(r'C:UserslukasOneDriveDokumenteStudiumBachelorBachelorarbeitDatenrichtw2018.shp')

Or you could use the well known text (wkt) column to create a geodataframe from your dataframe:

import pandas as pd

import geopandas as gpd

from shapely import wkt



#Create some test data, skip this step

d = {'col1':[1],'wkt':['POLYGON ((30 10, 40 40, 20 40, 10 20, 30 10))']}

df = pd.DataFrame(data=d)



#Use wkt.loads to return geomety objects

df['wkt'] = df['wkt'].apply(wkt.loads)



#Create geodataframe from dataframe, change epsg code to match your spatial reference

gdf = gpd.GeoDataFrame(df,geometry='wkt',crs={'init':'epsg:3006'})

edited 2 hours ago

answered 2 hours ago

BERA

16.1k52042

The way you are doing it is the correct way. Maybe the shapefile is corrupt? Try adding r to your path so the backslashes are interpreted correctly:

df = gdp.read_file(r'C:UserslukasOneDriveDokumenteStudiumBachelorBachelorarbeitDatenrichtw2018.shp')

Or you could use the well known text (wkt) column to create a geodataframe from your dataframe:

import pandas as pd

import geopandas as gpd

from shapely import wkt



#Create some test data, skip this step

d = {'col1':[1],'wkt':['POLYGON ((30 10, 40 40, 20 40, 10 20, 30 10))']}

df = pd.DataFrame(data=d)



#Use wkt.loads to return geomety objects

df['wkt'] = df['wkt'].apply(wkt.loads)



#Create geodataframe from dataframe, change epsg code to match your spatial reference

gdf = gpd.GeoDataFrame(df,geometry='wkt',crs={'init':'epsg:3006'})

edited 2 hours ago

answered 2 hours ago

BERA

16.1k52042

edited 2 hours ago

answered 2 hours ago

BERA

16.1k52042

answered 2 hours ago

BERA

16.1k52042

answered 2 hours ago

BERA

16.1k52042

Thank you for your response! Unfortunatelly I still couldnt fix the problem. When I am using apply (wkt.loads) , I get the Error Message: string or integer address expected instead of Polygon instance... Can you maybe help out? THX!

– Lukas
2 hours ago

Sounds like your data frame is in fact a geodataframe

– BERA
2 hours ago

1

Okay, I just downloaded the file again and now it is working. Thank you anyway for your help!

– Lukas
1 hour ago

add a comment |

Thank you for your response! Unfortunatelly I still couldnt fix the problem. When I am using apply (wkt.loads) , I get the Error Message: string or integer address expected instead of Polygon instance... Can you maybe help out? THX!

– Lukas
2 hours ago

Sounds like your data frame is in fact a geodataframe

– BERA
2 hours ago

1

Okay, I just downloaded the file again and now it is working. Thank you anyway for your help!

– Lukas
1 hour ago

Thank you for your response! Unfortunatelly I still couldnt fix the problem. When I am using apply (wkt.loads) , I get the Error Message: string or integer address expected instead of Polygon instance... Can you maybe help out? THX!

– Lukas
2 hours ago

Sounds like your data frame is in fact a geodataframe

– BERA
2 hours ago

Okay, I just downloaded the file again and now it is working. Thank you anyway for your help!

– Lukas
1 hour ago

add a comment |

Lukas is a new contributor. Be nice, and check out our Code of Conduct.

draft saved

draft discarded

Lukas is a new contributor. Be nice, and check out our Code of Conduct.

Thanks for contributing an answer to Geographic Information Systems Stack Exchange!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Vjylku