Aprende Reading Audience Data from CSV | Analyzing and Visualizing Audience Data

Desliza para mostrar el menú

Content creators often collect audience engagement data—such as views, likes, and comments—from platforms like YouTube or Instagram. This data is frequently exported in CSV files, a widely used format for storing tabular information. CSV stands for "Comma-Separated Values," where each line represents a row of data and each value is separated by a comma. Understanding how to read and process CSV files in Python allows you to efficiently analyze your audience's behavior and engagement patterns.


              1234567891011121314
            
import csv
from io import StringIO

csv_data = """video_title,views,likes,comments
How to Edit Photos,1200,150,12
Python Automation Tips,2000,300,25
Content Planning Basics,950,120,8
"""

reader = csv.reader(StringIO(csv_data))
header = next(reader)  # Skip header row

for row in reader:
    print("Title:", row[0], "| Views:", row[1], "| Likes:", row[2], "| Comments:", row[3])

When working with CSV files, each row corresponds to a set of related data, and each column holds a specific type of information (such as video titles, view counts, or likes). After reading the file, you can access individual columns by their position in the row list. For example, row[1] gives you the number of views for a video, while row[2] gives you the likes. By iterating through each row, you can collect or analyze specific metrics as needed.


              12345678910111213141516171819202122232425
            
import csv
from io import StringIO

csv_data = """video_title,views,likes,comments
How to Edit Photos,1200,150,12
Python Automation Tips,2000,300,25
Content Planning Basics,950,120,8
"""

reader = csv.reader(StringIO(csv_data))
header = next(reader)

total_views = 0
total_likes = 0
row_count = 0

for row in reader:
    total_views += int(row[1])
    total_likes += int(row[2])
    row_count += 1

average_likes = total_likes / row_count if row_count else 0

print("Total views:", total_views)
print("Average likes per video:", average_likes)

1. What is the advantage of using CSV files for data storage?

2. Which Python module is used for reading CSV files?

3. Fill in the blank: To read a CSV file, use csv.____(filename).

¿Todo estuvo claro?

¡Gracias por tus comentarios!

Sección 2. Capítulo 1

Pregunte a AI

Pregunte lo que quiera o pruebe una de las preguntas sugeridas para comenzar nuestra charla

Sección 2. Capítulo 1