FilesExpand file tree

 main

/

03-csv.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

27 lines (21 loc) · 616 Bytes

 main

/

03-csv.py

Copy path

Top

File metadata and controls

• Code
• Blame

27 lines (21 loc) · 616 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

import pandas as pd

import numpy as np

# Read CSV file

df = pd.read_csv('sales_basic.csv')

# Basic exploration

print("Dataset shape:", df.shape)

print("\nFirst 3 rows:")

print(df.head(3))

print("\nData types:")

print(df.dtypes)

# Simple operations

df['total_value'] = df['price'] * df['quantity']

print("\nDataset with calculated total value:")

print(df)

# Basic filtering

expensive_products = df[df['price'] > 700]

print("\nProducts with price > 700:")

print(expensive_products)

# Simple aggregation

total_revenue = df['total_value'].sum()

print(f"\nTotal revenue: ${total_revenue}")