Reading

Introduction to Data Frame

DataFrame is a data structure 2 dimensions that its columns have label and mostly have different data type.

Import Data from Microsoft Excel to Data Frame

<aside> <img src="/icons/snowflake_purple.svg" alt="/icons/snowflake_purple.svg" width="40px" /> Data format in Microsoft Excel generally consist of rows and columns with rows function as label consist of rows under that column.

Data format in Microsoft Excel the newest is .xlsx. This data format is commonly used to accommodate storage and processing data in large dataset but cannot be more superior in term of collaboration with other people. Because to open and process it, people need to install Microsoft Excel software in their computer.

</aside>

How to Import Data from Ms. Excel

Run the code below to import data from Microsoft Excel file into Data Frame.

df excel = pd.read_excel('Online Retail Data.xlsx', sheet_namee='Online Retail Data', header=0)
df_excel

Note: When we had more than 1 worksheet in an excel, we can call the tab’s name on parameter sheet_name