Q.Write the statement which will sort the marks in English in the DataFrame df based on Unit Test 3, in descending order.

DataFrame Creation: A First Look

Think of a spreadsheet you might use to track your monthly expenses. You have rows — one for each day or each purchase — and columns with labels like "Date", "Item", "Category", "Amount", and "Payment Method". That grid of labelled rows and columns is exactly what a DataFrame is in computing. It is a two-dimensional, table-like structure for storing and working with data.

The word "DataFrame" comes from two ideas: data (the information itself) and frame (the structure that holds it together). You can imagine it as a digital filing cabinet where every drawer (column) has a name, every folder (row) has a number, and every cell contains a single piece of information — a date, a word, a number, or even a missing entry.

The Core Idea

A DataFrame is not just a random collection of numbers and text. It is an organised table where:

• Each column represents a specific attribute or variable — for example, "Product Name", "Quantity Sold", "Price per Unit".
• Each row represents a single observation or record — one sale, one customer, one transaction.
• Every column has a label (its name), and every row has an index (its position or label).

This organisation is what makes a DataFrame powerful. You can ask questions like "Show me all rows where the category is 'Groceries'" or "What is the average amount spent in March?" — and the structure gives you a clear, fast way to get answers.

How a DataFrame Is Created

Creating a DataFrame means taking raw data and arranging it into this labelled table. The data can come from many places:

• A list of dictionaries, where each dictionary is one row and the keys become column names.
• A dictionary of lists, where each key is a column name and the list holds the values for that column.
• A CSV file (a comma-separated values file) that you read from your computer.
• Data entered manually, row by row.

Why It Matters

For a commerce or humanities student, the DataFrame is the single most useful tool for working with real-world data. Think of a small business tracking its inventory: the owner needs to see product names, stock levels, reorder dates, and supplier details all in one place. A DataFrame lets them do that, and then filter, sort, or summarise the information without rewriting everything by hand.

In academic work — analysing survey responses, comparing economic indicators across years, or studying historical records — the DataFrame turns messy, scattered data into a clean, queryable table. You can add new columns (like "Profit" calculated from "Revenue" minus "Cost"), remove rows that are incomplete, or merge two tables on a common column (like matching customer IDs from a sales table with names from a customer table).