Geek Slack

Course Content
Working with Pandas DataFrame
A DataFrame is the core data structure in Pandas, providing a two-dimensional table for storing data. It is similar to a spreadsheet or SQL table and consists of rows and columns, where each column can be of a different data type (e.g., integer, float, string).DataFrames are extremely versatile and essential for data manipulation and analysis tasks. You can create, manipulate, and analyze data stored in DataFrames with a variety of operations that are both powerful and easy to use.
0/7
Working with Date and Time in Pandas
Handling date and time data is an essential part of data analysis. Pandas provides robust functionality for working with time series data, allowing you to parse, manipulate, and perform various operations on date and time information. This chapter will guide you through the essential tools and methods provided by Pandas to handle date and time data effectively.Pandas offers the datetime module along with its own Timestamp and DatetimeIndex classes to work with time data. It also provides a set of methods for parsing, converting, and manipulating time-related data.
0/5
Working with Text Data in Pandas
Text data, also known as string data, is one of the most common data types encountered in data analysis. In Pandas, strings are represented as object dtype, which is typically used for text or mixed types. Pandas provides a variety of functions to efficiently handle and manipulate text data, whether you're cleaning, transforming, or extracting meaningful information.This chapter will guide you through the various tools and techniques that Pandas provides for working with text data. We’ll explore string manipulation methods, cleaning operations, and more advanced use cases like extracting specific patterns using regular expressions.
0/4
Pandas Tutorial
    About Lesson

    You can easily modify DataFrames by adding or deleting columns, changing values, or applying transformations.

    1. Adding a New Column

    To add a new column, you simply assign a list or a scalar value to a new column name.

    df['Country'] = ['USA', 'USA', 'USA']
    print(df)
    
    2. Modifying Existing Data

    You can modify data by referencing specific rows and columns:

    df.at[1, 'Age'] = 32  # Modify a specific value
    df['Age'] = df['Age'] + 1  # Apply a transformation to an entire column
    print(df)
    
    3. Deleting Columns

    To delete a column, use drop:

    df = df.drop('Country', axis=1)  # axis=1 refers to columns
    print(df)
    
    4. Deleting Rows

    To delete rows, use drop with axis=0 (default):

    df = df.drop(1, axis=0)  # Drop the second row (index 1)
    print(df)