Practical Example: Reading Server Inventory CSVs

🏷️ File Handling / CSV Files

📚 All-in-One📖 Theory Only💻 Code Only

🧠 Context Introduction

As engineers, you'll frequently work with CSV files containing server inventory data. These files might list hostnames, IP addresses, operating systems, CPU cores, memory, and disk space. Learning to read and process this data with Python is a foundational skill for automation, reporting, and monitoring tasks. This example walks through reading a real-world server inventory CSV and extracting meaningful information.

📂 Sample CSV Structure

Imagine a file named server_inventory.csv with the following columns:

Hostname – The server's name
IP_Address – Management IP
OS – Operating system (e.g., Ubuntu 20.04, Windows Server 2019)
CPU_Cores – Number of CPU cores
RAM_GB – Memory in gigabytes
Disk_GB – Total disk space in gigabytes
Status – Online, Offline, Maintenance

A typical row might look like:

web-server-01, 192.168.1.10, Ubuntu 20.04, 4, 16, 500, Online

⚙️ Step 1: Opening and Reading the CSV File

The first step is to open the file and read its contents. Python's built-in csv module handles this cleanly.

Import the csv module at the top of your script.
Use the open() function with the filename and mode 'r' (read).
Wrap the file object with csv.reader() to parse each row into a list.
Use a for loop to iterate through each row.

The file object should be closed automatically using a with statement. This ensures the file is properly closed even if an error occurs.

🕵️ Step 2: Skipping the Header Row

CSV files usually have a header row with column names. You want to skip this when processing data.

Call next(reader) once before your loop to advance past the header row.
The header row is still available if you need to verify column names later.

📊 Step 3: Extracting and Displaying Server Information

Once you have each row as a list, you can access individual fields by index. For example:

Index 0 = Hostname
Index 1 = IP_Address
Index 2 = OS
Index 3 = CPU_Cores
Index 4 = RAM_GB
Index 5 = Disk_GB
Index 6 = Status

You can print a formatted summary for each server, such as:

🛠️ Step 4: Filtering Servers by Condition

Often you need to find specific servers, like all servers with Status = 'Offline' or servers with RAM_GB >= 32.

Use an if statement inside your loop to check the value at the relevant index.
For numeric comparisons, convert the string value to an integer using int().
Print only the rows that match your condition.

Example condition: if row[6] == 'Offline': – prints only offline servers.

📋 Comparison Table: Reading Methods

Method	Use Case	Pros	Cons
csv.reader	Simple row-by-row access	Easy to use, lightweight	Must remember column indices
csv.DictReader	Access columns by name	More readable code, uses header names	Slightly more memory overhead
pandas.read_csv	Large datasets, analysis	Powerful filtering, statistics	External library, heavier

For most inventory tasks, csv.DictReader is recommended because you can reference columns by name (e.g., row['Hostname']) instead of numeric indices.

🧪 Step 5: Handling Missing or Malformed Data

Real-world CSV files often have missing values or inconsistent formatting.

Check if a field is empty using if not row[column]: before using it.
Wrap numeric conversions in a try/except block to catch ValueError when a string cannot be converted to an integer.
Print a warning message for rows that fail validation, but continue processing the rest of the file.

🚀 Putting It All Together

A complete script would:

Open server_inventory.csv using with open(...) as file:
Create a csv.DictReader object for named access.
Loop through each row.
For each server, print a formatted line with all details.
After the loop, print a summary count like Total servers processed: 25.
Optionally, print a filtered list such as Offline servers: 3.

✅ Key Takeaways

The csv module is part of Python's standard library – no extra installs needed.
Always use with open() to safely handle file resources.
csv.DictReader makes your code more readable and maintainable.
Always validate and clean data before using it in calculations or decisions.
Start simple: read all rows, then add filtering and error handling step by step.

📚 Next Steps

Try writing a filtered CSV with only online servers.
Add logic to calculate average CPU cores or total RAM across all servers.
Extend the script to accept the filename as a command-line argument.
Explore pandas for more advanced data manipulation when your inventory grows large.

Happy scripting – your server inventory is now just a Python script away from being fully automated!

This guide shows how to read server inventory data from CSV files using Python's built-in csv module.

📄 Example 1: Reading a CSV file line by line

This example opens a CSV file and prints each row as a list of values.

import csv

with open('server_inventory.csv', mode='r') as file:
    reader = csv.reader(file)
    for row in reader:
        print(row)

📤 Output: ['hostname', 'ip_address', 'os', 'ram_gb'] ['web01', '192.168.1.10', 'Ubuntu', '16'] ['db01', '192.168.1.20', 'CentOS', '32'] ['app01', '192.168.1.30', 'Ubuntu', '8']

📄 Example 2: Skipping the header row

This example reads the CSV but skips the first row (column names) using next().

import csv

with open('server_inventory.csv', mode='r') as file:
    reader = csv.reader(file)
    header = next(reader)
    print("Header:", header)
    for row in reader:
        print(row)

📤 Output: Header: ['hostname', 'ip_address', 'os', 'ram_gb'] ['web01', '192.168.1.10', 'Ubuntu', '16'] ['db01', '192.168.1.20', 'CentOS', '32'] ['app01', '192.168.1.30', 'Ubuntu', '8']

📄 Example 3: Reading CSV as dictionaries

This example reads each row as a dictionary where column names become keys.

import csv

with open('server_inventory.csv', mode='r') as file:
    reader = csv.DictReader(file)
    for row in reader:
        print(row)

📤 Output: {'hostname': 'web01', 'ip_address': '192.168.1.10', 'os': 'Ubuntu', 'ram_gb': '16'} {'hostname': 'db01', 'ip_address': '192.168.1.20', 'os': 'CentOS', 'ram_gb': '32'} {'hostname': 'app01', 'ip_address': '192.168.1.30', 'os': 'Ubuntu', 'ram_gb': '8'}

📄 Example 4: Filtering servers by operating system

This example reads the CSV and prints only servers running Ubuntu.

import csv

with open('server_inventory.csv', mode='r') as file:
    reader = csv.DictReader(file)
    for row in reader:
        if row['os'] == 'Ubuntu':
            print(f"{row['hostname']} - {row['ip_address']} - {row['ram_gb']}GB RAM")

📤 Output: web01 - 192.168.1.10 - 16GB RAM app01 - 192.168.1.30 - 8GB RAM

📄 Example 5: Calculating total RAM across all servers

This example sums the RAM values from all servers in the inventory.

import csv

total_ram = 0

with open('server_inventory.csv', mode='r') as file:
    reader = csv.DictReader(file)
    for row in reader:
        total_ram += int(row['ram_gb'])

print(f"Total RAM across all servers: {total_ram} GB")

📤 Output: Total RAM across all servers: 56 GB

Comparison Table

Method	Returns	Best For
csv.reader()	List of strings per row	Simple row-by-row processing
csv.DictReader()	Dictionary per row	Accessing columns by name