Dear all,
I have a variable called place_birth in my dataset. Some of the locations weren't recorded properly.
place_birth
Feucherolles (Saint-James = Le château royal de Sainte-Gemme)
ST B(?), canton de Chaillot
(?Chanvrand)Canton de La Guiche
Seine-Inférieure (Seine-Maritime)
Épinay-sur-Seine ,
Autine (?) Outines
Darrois ? Darvois
I would like to do two things.
First, separate what is inside parenthesis () and comma , and = from the text. With what I separate I can create an new variable called place_new
Second, clean both variable from weird signs like ?, =, . at the end, /, etc...
For example
Épinay-sur-Seine ,
should look like
Épinay-sur-Seine
replace ? and (?) with a comma
Autine (?) Outines
it becomes
Autine , Outines
For this one:
Feucherolles (Saint-James = Le château royal de Sainte-Gemme)
Eliminate "Saint-James =" and just leave:
Feucherolles (Le château royal de Sainte-Gemme)
Then I can separate the strings by comma and parenthesis so that for example:
place_birth
(?Chanvrand)Canton de La Guiche
becomes:
place_new
Chanvrand
Or:
place_birth
Seine-Inférieure (Seine-Maritime)
Becomes in the new var:
place_new
Seine-Maritime
Related Posts with Cleaning string variable
A question on insheetjson - Keep getting "Invalid column name/selector" error message when using -insheetjson-I am trying to get some data from the API of American Community Survey by using insheetjson. But whe…
How to tag the most recent fiscal year end value based on the calandar time?Dear Stata experts, I would like to find the most recent fiscal-year-end investment based on the ca…
How to deal with non-linear relationships in linear modelsDear all, I estimated a linear regression model on multiply imputed data. I regress income on a ran…
marginal effects after bayesian mlogitDear all, I'm running a bayesian mlogit model using the "bayes:" prefix and I'm trying to compute ma…
Creating a Panel and Column namesHi, How could get the first row first Column: Germany to become a panel (so to match each observati…
Subscribe to:
Post Comments (Atom)
0 Response to Cleaning string variable
Post a Comment