Date TIme in Python for data scientists

python date datatype- datetime
pandas date datatype- Timestamp

1) creating pandas datframe with string dates value

## datetime
date_data= pd.DataFrame(np.random.randint(10,100, (4,3)), columns=['A','B','C'])
dates= ['2 june 2013', '5 Aug 2015', '2015-07-09', '7/12/2014']
date_data.index= dates

A B C
2 june 2013 52 61 89
5 Aug 2015 21 69 89
2015-07-09 88 23 13
7/12/2014 43 39 21
creating string into pandas datetime format-

date_data.index= pd.to_datetime(date_data.index)
date_data

A B C
2013-06-02 59 93 77
2015-08-05 33 15 28
2015-07-09 63 19 25
2014-07-12 29 36 92
2) Time difference in pandas-

pd.Timestamp('12.03.2019')- pd.Timestamp('12 Aug 2018')

Timedelta('478 days 00:00:00')

3) Return a fixed frequency DatetimeIndex -


cum_array= pd.DataFrame({'colA': np.random.randint(1,5,9).cumsum(), 'colB': np.random.randint(-4,10,9)}) dates=pd.date_range('10-10-2019','15-10-2019', periods=9) cum_array.index= dates cum_array.diff() # provides difference

4) plotting time series

import matplotlib.pyplot as plt
%matplotlib inline
cum_array.plot()

<matplotlib.axes._subplots.AxesSubplot at 0x2fd605b8be0>
In [ ]:

Comments

Post a Comment

Popular posts from this blog

Speech Recognition using PyAudio and SpeechRecognition Libraries

This is simple program to convert audio into text. I have used speec_recognition library to do it. import speech_recognition as sr r = sr.Recognizer() with sr.Microphone() as source:     print("Speak Anything :")     audio = r.listen(source)     try:         text = r.recognize_google(audio)         print("You said : {}".format(text))     except:         print("Sorry could not recognize what you said") Output- Speak Anything : You said : internet is required to access the Google API if there is no internet you will not be able to convert voice into text to install SpeechRecognition- https://pypi.org/project/SpeechRecognition/ one of the dependencies is PyAudio which is not supported after 3.6. For python verison 3.6+ one needs to download wheel (  https://python101.pythonlibrary.org/chapter39_wheels.html )  and install PyAudio separately. https://sta...
Read more

Automatically open and do some actions on web pages in python using different packages

1) Automatically open web url using Selenium- get chrome driver from here- https://chromedriver.storage.googleapis.com/index.html?path=80.0.3987.106  place the chrome driver in user/username/bin location from selenium import webdriver browser = webdriver.Chrome(executable_path = '/Users/abcarp/bin/chromedriver') browser.get('https://in.linkedin.com/') sleep(10) browser.close() 2) Automatically login to Linkedin and do some action using selenium- from selenium.webdriver.common.keys import Keys      # url of LinkedIn  url = "https://www.linkedin.com/login?fromSignIn=true&trk=guest_homepage-basic_nav-header-signin"   # path to browser web driver  driver = webdriver.Chrome( '/Users/esisarp/bin/chromedriver')       driver.get(url)  # getting the user-name element username = driver.find_element_by_id("username")   # Sending the keys for username        username.s...
Read more

open multiple sites in python Script using web browser package

including required packages- ! pip install random ! pip install webbrowser import random import webbrowser import os adding multiple sites in a list- ls=['/2016/08/business-analytics-on-sales-data-of.html', '/recommendation-engine-market-basket.html', '/2016/08/optimizing-e-commerce-site-using.html'    ,'/2016/08/8-simple-ways-to-increse-your-blog.html', '/2016/08/business-analytics-on-sales-data-of.html',    '/2017/12/gaussian-state-space-model-in-r-using.html', '/2017/09/assumptions-of-linear-regression.html',    '/2017/09/neural-network-forward-propagation-in.html', '/2018/06/lda-linear-discriminant-analysis-where.html',    '/2018/10/religious-demographics-of-india-in.html', '/2020/04/forecasting-total-deaths-from.html',    '/2019/11/automatic-ticket-resolution-for.html', '/2019/09/sentiment-analysis-using-nltk-and.html', '/2019/07/deep-learning-with-h2o-in-py...
Read more