In [5]:
import pandas # importando as bibliotecas
import numpy
import matplotlib
import ggplot
dados = pandas.read_csv("USAID_2014_Commuter_Survey_Data.csv") #importando o csv
In [6]:
dados.head(10)
Out[6]:
User Code
1 Please select your operating administration or office:
2 Begin typing your work zip code and select your work site from the list that will appear below. If your site does not appear in the list select 'Site not found'. If you telework 100% of the time please select the site to which you officially report.
3 What is your employment status?
4 How did you travel TO WORK each day during a TYPICAL week? If you select 'N/A' for transportation method select 'N/A' for # Miles.
Monday
Monday Miles 1
Monday.1
Monday Miles 2
Monday.2
...
13 Is there any information you would like to add about your commute that was not addressed in this survey?
14 Were the survey questions clear?
15 Did you experience any technical problems while taking this survey?
Survey site was slow to load some/all questions
I was unable to connect to the survey on my first try
My survey link did not work
I had another technical problem not addressed here
I did not have any technical problems
16 How was your overall experience with this survey?
CO2e Emissions (CO2e MT) / year
0
01A1EJ9V
U.S. Agency for International Development
Site not found
Federal Government Employee
NaN
Car (drove alone)
5
NaN
NaN
NaN
...
NaN
Yes. I understood all of the questions withou...
NaN
off
off
off
off
on
Favorable. I did not experience any problems.
0.443200
1
01TOQN5I
U.S. Agency for International Development
USAID5 - Ronald Reagan Building - 1300 Pennsyl...
Federal Government Employee
NaN
Bicycle
10
Transit rail (e.g. subway)
10
NaN
...
NaN
Yes. I understood all of the questions withou...
NaN
off
off
off
off
on
Favorable. I did not experience any problems.
1.097644
2
02BLP4WU
U.S. Agency for International Development
USAID5 - Ronald Reagan Building - 1300 Pennsyl...
Federal Government Employee
NaN
Transit bus
2
Transit rail (e.g. subway)
5
Walk
...
NaN
Yes. I understood all of the questions withou...
NaN
off
off
off
off
on
Favorable. I did not experience any problems.
0.475113
3
0407RZXE
U.S. Agency for International Development
USAID2 - 2 Potomac Yards - 2733 Crystal City D...
Federal Government Employee
NaN
Carpool/Vanpool
30
NaN
NaN
NaN
...
NaN
Yes. I understood all of the questions withou...
NaN
off
off
off
off
on
Favorable. I did not experience any problems.
1.474740
4
06EWZXIN
U.S. Agency for International Development
USAID5 - Ronald Reagan Building - 1300 Pennsyl...
Federal Government Employee
NaN
Car (drove alone)
8
NaN
NaN
NaN
...
USAID has a great telework and AWS program on ...
Yes. I understood all of the questions withou...
NaN
off
off
off
off
on
Favorable. I did not experience any problems.
1.378421
5
096ODJ8X
U.S. Agency for International Development
Site not found
Federal Government Employee
NaN
Carpool/Vanpool
15
Transit rail (e.g. subway)
10
NaN
...
NaN
Yes. I understood all of the questions withou...
NaN
off
off
off
off
on
Favorable. I did not experience any problems.
2.045308
6
0AXW6GWP
U.S. Agency for International Development
Site not found
Federal Government Employee
NaN
Commuter rail (e.g. regional)
20
Walk
<1
NaN
...
NaN
Yes, but a few of the questions were confusing.
NaN
off
off
off
off
on
Neutral. I had a few problems with the survey...
1.585638
7
0B8TXXZF
U.S. Agency for International Development
Site not found
Federal Government Employee
NaN
Transit bus
<1
Transit rail (e.g. subway)
4
NaN
...
A question related to the weather and commutin...
Yes. I understood all of the questions withou...
NaN
off
off
off
off
on
Favorable. I did not experience any problems.
0.301215
8
0BGM8DL0
U.S. Agency for International Development
USAID1 - 1401 H Street NW - 1401 H Street NW, ...
Federal Government Employee
NaN
Transit bus
1
Transit rail (e.g. subway)
4
NaN
...
NaN
Yes. I understood all of the questions withou...
NaN
off
off
off
off
on
Neutral. I had a few problems with the survey...
0.350512
9
0D3CACJG
U.S. Agency for International Development
USAID5 - Ronald Reagan Building - 1300 Pennsyl...
Federal Government Employee
NaN
Transit rail (e.g. subway)
10
NaN
NaN
NaN
...
NaN
Yes. I understood all of the questions withou...
NaN
off
off
off
off
on
Favorable. I did not experience any problems.
0.753038
10 rows × 90 columns
In [7]:
dados.describe()
Out[7]:
4 How did you travel TO WORK each day during a TYPICAL week? If you select 'N/A' for transportation method select 'N/A' for # Miles.
7 How did you travel FROM WORK each day during a TYPICAL week? If you select 'N/A' for transportation method select 'N/A' for # Miles.
Friday Miles 2.1
8 What is the average total number of people in the Carpool/Vanpool you selected above including yourself? (Select 'N/A' if not applicable.)
If 'other' selected please indicate commuting method:
11 Overall how satisfied are you with the following?
15 Did you experience any technical problems while taking this survey?
CO2e Emissions (CO2e MT) / year
count
0
0
25.000000
9.000000
0
0
0
1138.000000
mean
NaN
NaN
6.680000
3.222222
NaN
NaN
NaN
1.409558
std
NaN
NaN
8.576713
2.635231
NaN
NaN
NaN
2.166914
min
NaN
NaN
1.000000
2.000000
NaN
NaN
NaN
0.000000
25%
NaN
NaN
2.000000
2.000000
NaN
NaN
NaN
0.225912
50%
NaN
NaN
2.000000
2.000000
NaN
NaN
NaN
0.677735
75%
NaN
NaN
8.000000
3.000000
NaN
NaN
NaN
1.723027
max
NaN
NaN
38.000000
10.000000
NaN
NaN
NaN
26.102144
Content source: august-o/august-o.github.io
Similar notebooks: