-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathtest3.py
More file actions
28 lines (23 loc) · 1.08 KB
/
Copy pathtest3.py
File metadata and controls
28 lines (23 loc) · 1.08 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
import numpy as np
import pandas as pd
# Print something
# df = pd.read_csv("short.csv")
# print(df.head())
# Read Specific Columns
# df = pd.read_csv("short.csv", usecols=["ride_id", "started_at", "ended_at", "start_station_name", "member_casual"], nrows=3, parse_dates=["started_at", "ended_at"])
# print(df)
# Describe
# data = pd.read_csv('short.csv')
# print("Bike Share:")
# print(data.head())
# print("\nSummary Table Generated by .describe() Method:")
# print(data.describe())
# Subtract
# df = pd.read_csv("short.csv", usecols=["ride_id", "started_at", "ended_at", "start_station_name", "member_casual"], parse_dates=["started_at", "ended_at"])
# df["ride_time_mins"] = np.round((df["ended_at"] - df["started_at"]).dt.total_seconds()/60, 1);
# print(df)
# Real data
# df = pd.read_csv("data/202606-capitalbikeshare-tripdata.csv", usecols=["ride_id", "started_at", "ended_at", "start_station_name", "member_casual"], parse_dates=["started_at", "ended_at"])
# df["ride_time_mins"] = np.round((df["ended_at"] - df["started_at"]).dt.total_seconds()/60, 1)
# print(df.head())
# print(df.describe())