Date time

Question 1

If you want to combine columns to have dates how do you do it?

Answer 1

pd.read_csv(url, parse_dates = [[0,1,2]]

Question 2

When the index is a date, how do you select different dates?

Answer 2

df. loc(‘1996-08-01’)

df. index.month == 1

Question 3

If you want to convert to datetime format how do you do it?

Answer 3

1) parse dates when importing

2) . pd.to_datetime

Question 4

Alias for year end?

Answer 4

A, Y

Question 5

Alias for year start?

Answer 5

AS, YS

Question 6

Alias for weekly

Answer 6

W

Question 7

Alias for month end?

Answer 7

M

Question 8

Alias for month start?

Answer 8

MS

Question 9

Alias for business mont end/

Answer 9

BM

Question 10

Alias for quarter?

Answer 10

Q

Question 11

Alias for business quarter end

Answer 11

BQ

Question 12

How do you get isoformat dates?

Answer 12

datename.isoformat()

Question 13

What is the method for converting a date into a string?

Answer 13

strftime

Question 14

How do you get the month fully written out?

Answer 14

strftime(‘%B’)

Question 15

How do you change bits of a datetime format?

Answer 15

dt.replace(minutes = 12)

Question 16

How do you output datetime as strings?

Answer 16

variablenamehere.strftime(‘%Y’)

Question 17

How do you parse strings as datetime?

Answer 17

datetime.strptime(‘string in here’, ‘%Y’)

Question 18

What is the syntax for strftime?

Answer 18

variancename.strftime(‘%Y’)

Question 19

What is the syntax for strptime?

Answer 19

datetime.strptime(‘string’,’%y’)

Question 20

Which one has to have datetime in front?

Answer 20

datetime. strptime

variablename. strftime

Question 21

How do you get a timezone stored?

Answer 21

timezone(timedelta(hours = -5))

Question 22

When do you use replace and when do you use astimezone?

Answer 22

astimezone actually changes the stored time

replace just changes the offset

Question 23

How do you change the timezone?

Answer 23

variable.astimezone(timezone)

Question 24

How do you get timezones?

Answer 24

tz.gettz(‘Continent/City’)

Question 25

What is the module for getting timezones

Answer 25

from dateutil import tz

Question 26

How do you deal with daylight saving time?

Answer 26

Convert everything to UTC

Question 27

How do you get the duration between times as a number rather than a timedelta?

Answer 27

total_seconds()