Reading in a stata .dta file as a python pandas data frame using pd.read_stata()

Question

I want to read in an .dta file as a pandas data frame.

I've tried using code from https://www.fragilefamilieschallenge.org/using-dta-files-in-python/ but it gives me an error.

Thanks for any help!

import pandas as pd
df_path = "https://zenodo.org/record/3635384/files/B-PROACT1V%20Year%204%20%26%206%20child%20BP%2C%20BMI%20and%20PA%20dataset.dta?download=1"
df = None
with open(df_path, "r") as f:
    df = pd.read_stata(f)
    print df.head()

What error?????

ALollz
– ALollz

2020-08-10 17:36:02 +00:00
Commented Aug 10, 2020 at 17:36 — ALollz
– ALollz, Commented Aug 10, 2020 at 17:36
open is only for local files.

eduffy
– eduffy

2020-08-10 17:39:03 +00:00
Commented Aug 10, 2020 at 17:39 — eduffy
– eduffy, Commented Aug 10, 2020 at 17:39

Wouter · Accepted Answer · 2020-08-11 09:52:40Z

2

open can be used when you have a file saved locally on your machine. With pd.read_stata this is not necessary however, as you can specify the file path directly as a parameter.

In this case you want to read in a .dta file from a url so this does not apply. The solution is simple though, as pd.read_stata can read in files from urls directly.

import pandas as pd
url = 'https://zenodo.org/record/3635384/files/B-PROACT1V%20Year%204%20%26%206%20child%20BP%2C%20BMI%20and%20PA%20dataset.dta?download=1'
df = pd.read_stata(url)

edited Aug 11, 2020 at 9:52

answered Aug 11, 2020 at 9:42

Wouter

3,27110 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Reading in a stata .dta file as a python pandas data frame using pd.read_stata()

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related