Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

import pandas as pd import numpy as np dict = {'Day of week': ['Sunday', 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday'], 'Data': ['2017-01-01', '2017-01-02', '2017-01-03', '2017-01-04',

import pandas as pd import numpy as np

image text in transcribed

dict = {'Day of week': ['Sunday', 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday'], 'Data': ['2017-01-01', '2017-01-02', '2017-01-03', '2017-01-04', '2017-01-05', '2017-01-06', '2017-01-07']}

Create day of the week data frame

1) turn this dictionary into a data frame

2) print the first 5 rows

3) print the dimensions/shape

4) write this data to lab3c.csv and ensure to set the encoding to 'utf-8' and set the index parameter to 'False' in the call to create the csv file

J 1 2 3 4 5 6 7 8 A B D E F G . Duration Start date End date Start static Start static End statio End statio Bike numt Member Type 1048876 ######## ######## 31213 17th & KS 31606 Potomac & W20784 Registered 223449 ######## ######## 31104 Adams Mi 31103 16th & Ha W20825 Registered 423494 ######## ######## 31627 M St & De 31614 11th & H SW20773 Registered 687015 ######## ######## 31404 9th & Ups 31281 8th & O St W01307 Registered 257919 ######## ######## 31602 Park Rd & 31400 Georgia & W21760 Registered 253959 ######## ######## 31123 14th & Gin 31102 11th & Ker W23036 Registered 402669 ######## ### 31263 10th & KS 31109 7th & T St W22539 Registered 744377 ######## ######## 31236 37th & OS 31917 N Lynn St W20893 Casual 776845 ######## ######## 31111 10th & US 31404 9th & Ups W00945 Registered 212823 ######## ######## 31124 14th & Irv 31117 15th & Eu. W22998 Registered 338103 ######## ######## 31202 14th & RS 31109 7th & T St W20006 Registered 883046 ################ 31307 3000 Conr 31224 19th & LS W00382 Casual 534500 ######## ### 31111 10th & US 31278 18th & RSW01141 Registered 9 10 11 12 13 14

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Next Generation Databases NoSQLand Big Data

Authors: Guy Harrison

1st Edition

1484213300, 978-1484213308

More Books

Students also viewed these Databases questions