CSV File Examples

Overview

This page provides examples of Dataoris event data in CSV format, showing the structure and content of batch files.

Data Structure

Batch files use the same event structure as MQTT messages. For complete field descriptions, see:

• MQTT Message Example

CSV Format

Header Row

mm,cell_id,event_type,event_duration,created_at,brand,model,cfray,origin,adv_key,os,os_version,package_name

Sample Data

mm,cell_id,event_type,event_duration,created_at,brand,model,cfray,origin,adv_key,os,os_version,package_name
1220290060,8881839825fffff,EVENT_IN,-1,1767623650044,apple,iPhone14.2,55e5fg9e5ege4hgh-POA,beacon,com.grouplinknetwork.app,iOS,26.1,com.grouplinknetwork.app
1220290061,88a8100ecdfffff,EVENT_IN,-1,1767623750044,samsung,SM-G998B,abc123def456-GRU,beacon,com.grouplinknetwork.app,Android,14.0,com.grouplinknetwork.app
1220290062,8881839825fffff,EVENT_IN,-1,1767623850044,apple,iPhone15.3,xyz789abc012-POA,beacon,com.grouplinknetwork.app,iOS,17.2,com.grouplinknetwork.app

Field Descriptions

Column	Type	Description	Example
mm	number	Unique mobile identifier	1220290060
cell_id	string	H3 cell identifier	"8881839825fffff"
event_type	string	Event type	"EVENT_IN"
event_duration	number	Duration in ms	-1
created_at	number	Unix timestamp (ms)	1767623650044
brand	string	Device brand	"apple"
model	string	Device model	"iPhone14.2"
cfray	string	CloudFlare ray ID	"55e5fg9e5ege4hgh-POA"
origin	string	Signal origin	"beacon"
adv_key	string	Advertising key	"com.app.example"
os	string	Operating system	"iOS"
os_version	string	OS version	"26.1"
package_name	string	App package name	"com.example.app"

Reading CSV Files

Python Example

import pandas as pd

# Read the CSV file
df = pd.read_csv('dataoris_events_2026-01-22.csv')

# Display basic information
print(f"Total events: {len(df)}")
print(f"Unique devices: {df['mm'].nunique()}")
print(f"Unique cells: {df['cell_id'].nunique()}")

# Group by event type
print(df['event_type'].value_counts())

# Filter by cell_id
specific_cell = df[df['cell_id'] == '8881839825fffff']
print(f"Events in specific cell: {len(specific_cell)}")

Expected Output

Total events: 15234
Unique devices: 8456
Unique cells: 234
event_type
EVENT_IN    15234
Name: count, dtype: int64
Events in specific cell: 45

File Size Estimates

Typical file sizes for Dataoris batch CSV files:

Events	CSV Size (uncompressed)	CSV.GZ Size (compressed)
10,000	~1.2 MB	~400 KB
100,000	~12 MB	~3.5 MB
1,000,000	~115 MB	~32 MB

Data Quality

All batch files include:

• ✅ Validated event structure
• ✅ Deduplicated events
• ✅ Sorted by timestamp
• ✅ Complete device metadata

Next Steps

• Introduction: Return to Batch Integration overview
• MQTT Message Example: See complete field descriptions

Support

For questions about CSV file examples:

• Email: suporte@grouplinkone.com