Importing SAS files
In this exercise, you'll figure out how to
import a SAS file as a DataFrame using SAS7BDAT
and
pandas
. The file 'sales.sas7bdat'
is already
in your working directory and both pandas
and matplotlib.pyplot
have
already been imported as follows:
import pandas as pd
import matplotlib.pyplot as plt
The data are adapted from the website of the undergraduate text book Principles of Econometrics by Hill, Griffiths and Lim.
This is a part of the course
“Introduction to Importing Data in Python”
Exercise instructions
- Import the module
SAS7BDAT
from the librarysas7bdat
. - In the context of the file
'sales.sas7bdat'
, load its contents to a DataFramedf_sas
, using the method.to_data_frame()
on the objectfile
. - Print the head of the DataFrame
df_sas
. - Execute your entire script to produce a histogram plot!
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Import sas7bdat package
from ____ import ____
# Save file to a DataFrame: df_sas
with SAS7BDAT('sales.sas7bdat') as file:
____
# Print head of DataFrame
# Plot histogram of DataFrame features (pandas and pyplot already imported)
pd.DataFrame.hist(df_sas[['P']])
plt.ylabel('count')
plt.show()