Exploring Data using pandas

When you first load your data, it's important to perform initial checks to understand its structure, content, and the type of data it contains.

Viewing Data

Here's how you can take a peek at your DataFrame:

# Display the first five rows of the stocks DataFrame

# Display the last five rows of the sDataFrame

financials_df.head() displays the first few rows and can immediately flag missing data or anomalies.

financials_df.tail() shows you the end of the dataset, often revealing how recent the data is and whether it's been truncated.

Data Structure

An understanding of your DataFrame's structure is essential before diving into deeper analysis.

We can use stocks_df.info() to get a summary of the DataFrame, including the number of non-null entries and data types of each column. This can highlight if certain columns contain missing values that need to be addressed or if data types need conversion.

# Print a concise summary of the DataFrame

Descriptive Statistics

Descriptive statistics provide a high-level summary of the attributes of your dataset

  • stocks_df.describe() gives a statistical summary for numerical columns, useful for a quick assessment of distribution and variability.
  • Custom aggregations like stocks_df [' GOOGL '].mean() help in understanding specific aspects like the average.
# Get a statistical summary

# Find the average price for Google


For more specific summary statistics, you can use aggregation methods like mean(), median(), min(), max(), and sum():

# Calculate the average opening price

# Find the maximum closing price

The result The result will be 61.96290836653386 and 72.52.

Related Downloads

Learn the skills required to excel in data science and data analytics covering R, Python, machine learning, and AI.

Free Guides - Getting Started with R and Python

Enter your name and email address below and we will email you the guides for R programming and Python.

Saylient AI Logo

Take the Next Step in Your Data Career

Join our membership for lifetime unlimited access to all our data analytics and data science learning content and resources.