'%20stroke='%23C6EEFF'%20stroke-width='14'%20stroke-linejoin='round'%20d='M256%2052c86%200%20154%2068%20154%20154%200%2056-30%2092-60%20124-21%2022-33%2040-35%2066H197c-2-26-14-44-35-66-30-32-60-68-60-124%200-86%2068-154%20154-154z'/%3e%3c!--%20inner%20glow%20behind%20the%20filament%20--%3e%3ccircle%20cx='256'%20cy='250'%20r='104'%20fill='url(%23dpGlow)'/%3e%3c!--%20filament:%20glowing%20loop%20--%3e%3cpath%20fill='none'%20stroke='%23DFF6FF'%20stroke-width='18'%20stroke-linecap='round'%20stroke-linejoin='round'%20filter='url(%23dpSoft)'%20d='M212%20322v-52c0-30%2020-46%2044-46s44%2016%2044%2046v52'/%3e%3cpath%20fill='none'%20stroke='%23EAFBFF'%20stroke-width='9'%20stroke-linecap='round'%20stroke-linejoin='round'%20d='M212%20322v-52c0-30%2020-46%2044-46s44%2016%2044%2046v52'/%3e%3c!--%20glass%20sheen%20(reflective)%20--%3e%3cpath%20fill='%23FFFFFF'%20opacity='0.32'%20d='M150%20106c26-28%2062-44%2096-46-52%2016-84%2062-90%20118-4%2038%204%2074%2022%20106-40-24-66-64-66-116%200-24%206-44%2038-62z'/%3e%3c!--%20base%20cap:%20outlined%20like%20the%20glass%20so%20the%20plug%20end%20reads%20clearly%20--%3e%3crect%20x='210'%20y='398'%20width='92'%20height='20'%20rx='10'%20fill='url(%23dpCap)'%20stroke='%23C6EEFF'%20stroke-width='10'/%3e%3crect%20x='220'%20y='424'%20width='72'%20height='14'%20rx='7'%20fill='%231B3FA8'%20stroke='%23C6EEFF'%20stroke-width='8'/%3e%3crect%20x='228'%20y='444'%20width='56'%20height='14'%20rx='7'%20fill='%2316337F'%20stroke='%23C6EEFF'%20stroke-width='8'/%3e%3crect%20x='240'%20y='464'%20width='32'%20height='12'%20rx='6'%20fill='%2312307A'%20stroke='%23C6EEFF'%20stroke-width='7'/%3e%3c/svg%3e)
Data Analytics case 19: Exporting for Transport
Scenario
You are a data professional. A delivery van fleet has an issue: the finance team wants the bus_trips data as a file. As a Data Analyst, you are tasked to solve it.
Question
Save the table to CSV.
Your task
- Read the problem
- Write your solution in the editor
- Press Check my answer
- Deliverable: CSV export
- On success it is published as its own portfolio project
Data Analytics · Problem Solving & Root Cause Analysis — question 19 of 30
1. Choose your dataset
Pick an industry and a size. Your code and results change to match.
Data Analytics case 19: Exporting for Transport
Save the table to CSV.
Your code cell is below. Press Check my answer to run the cell — the result appears as Out [1].
💡 Explain my whole code, line by line (hover any word in the editor for a tip)
🌈 In short — no coding words
Altogether: this script runs top to bottom, one line at a time, building up the answer step by step.
Dataset & schema
bus_trips
The tiny starter data. Bigger data scrolls.
Fields
| trip_id | route | delay_minutes |
|---|---|---|
| T1 | R1 | 5 |
| T2 | R2 | 12 |
| T3 | R1 | 8 |
| T4 | R3 | 2 |
Transport data only.
$ Press “Check my answer” — results appear here.Your next steps
Each item turns green when your answer includes it.
- Saves CSV