Data Science with Python | Kanth

Discussion in 'Big Data and Analytics' started by Nishant_Singh, Jun 1, 2019.

  1. Nishant_Singh

    Nishant_Singh Well-Known Member
    Simplilearn Support

    Joined:
    Aug 1, 2018
    Messages:
    198
    Likes Received:
    14
    #1
  2. Satish Nalla_1

    Satish Nalla_1 New Member

    Joined:
    May 30, 2019
    Messages:
    1
    Likes Received:
    0
    hi testing
     
    #2
  3. amit kumar_94

    amit kumar_94 Member

    Joined:
    May 18, 2019
    Messages:
    3
    Likes Received:
    0
    could you please suggest the best book to start data science with python?, thanks
     
    #3
  4. _34601

    _34601 New Member
    Alumni

    Joined:
    Jul 13, 2018
    Messages:
    1
    Likes Received:
    1
    So much to cover on Data Science
     
    #4
    SUNNY BHAVEEN CHANDRA likes this.
  5. SUNNY BHAVEEN CHANDRA

    SUNNY BHAVEEN CHANDRA Active Member

    Joined:
    Feb 4, 2019
    Messages:
    20
    Likes Received:
    2
    Hey Amit,
    There are a lot of books in the market but before going through them I would like to suggest you to go through the self-learning course provided by simplilearn in your LMS for data science with python as it will help you to gain more insights into the course and also in live sessions. Most of the books like
    1.Hands-on Machine Learning with Scikit-Learn and TensorFlow,
    2.Python for Data Analysis: Data Wrangling with Pandas, NumPy, and Ipython,
    3.Python Data Science Handbook: Essential Tools for Working with Data
    etc are not that beginner friendly. So go through your current course and then you can follow these books for more insights.
    I hope this helps!
    Regards,
    Sunny
    Sr. Teaching Assistant
    Simplilearn
     
    #5
  6. Fasih Ahmed

    Fasih Ahmed Member

    Joined:
    May 22, 2019
    Messages:
    3
    Likes Received:
    2
    Hi Kanth,

    I have been trying to filter on a date column where date in csv file >= today date.
    but unfortunately, I am getting an error as below
    TypeError: '>' not supported between instances of 'builtin_function_or_method' and 'builtin_function_or_method'

    Here is my approach

    import pandas as pd
    import numpy as np
    import datetime as dt
    Todaysdate = dt.date.today

    df = pd.read_csv("Data.csv, parse_dates=['JobIDDate'], dayfirst=True")

    df1 = df[(df['JobIDDate'] >= Todaysdate)]

    While printing df1 getting the same error which i mentioned above.

    2nd approach is
    df[df'['JobIDDate'] >= Todaysdate]

    Request you to please I need to read whole csv but after that i need only those records which are greater than or equal to today's date and then i would store that data into a seprate csv file.
     

    Attached Files:

    #6
    SUNNY BHAVEEN CHANDRA likes this.
  7. Fasih Ahmed

    Fasih Ahmed Member

    Joined:
    May 22, 2019
    Messages:
    3
    Likes Received:
    2
    Hi please reply.
     
    #7
  8. Bhargav Jagathabhi

    Bhargav Jagathabhi New Member

    Joined:
    Apr 22, 2019
    Messages:
    1
    Likes Received:
    0
    Hi Armando,

    Confusion matrix printed with dimensions of 5x5? unlike in sessions which is 2x2.
    [[ 0 0 0 14155 0]
    [ 0 0 0 27084 0]
    [ 0 0 0 64852 0]
    [ 0 0 0 87473 0]
    [ 0 0 0 56489 0]]

    Can you let me know what would have went wrong?
     
    #8
  9. Amit_565

    Amit_565 New Member

    Joined:
    May 21, 2019
    Messages:
    1
    Likes Received:
    0
    Hello Kanth and All,
    i am fresher in coding and programming, i don't know a single word in programming , kindly help me ,how to start ,what is process i will apply ..i am so confused, i trying to understand the code logic but fails.
    Anyone suggest me please ...
     
    #9
  10. Srijith Kaladharan

    Joined:
    Mar 14, 2019
    Messages:
    3
    Likes Received:
    1
    Hi Kanth..

    I am not able to download the files from the google drive.
    The email id associated with my simplilearn account is an outlook e-mail account.
    Can you please help me with this?
     
    #10
  11. SUNNY BHAVEEN CHANDRA

    SUNNY BHAVEEN CHANDRA Active Member

    Joined:
    Feb 4, 2019
    Messages:
    20
    Likes Received:
    2
    Hi Fasih,

    The following code will work perfectly fine-
    Code:
    import pandas as pd
    import numpy as np
    df = pd.read_csv("Data.txt", sep="\t", parse_dates = ["JobIDDate"], dayfirst=True)
    Todaysdate = pd.datetime.today()
    print(Todaysdate)
    df1 = df[(df['JobIDDate'] >= Todaysdate)]
    df1
    My Comment on your code -
    1. Here today is a method so instead of Todaysdate = dt.date.today use Todaysdate = dt.date.today()
    2. Now no need to import datetime library separately as pandas too have the same you can check the code provided me.
    3. And there were few other errors in the code that I'm sure you'll figure out. https://www.stackoverflow.com is really a good friend for many developers. :p
    4. to save your CSV file you can use
    Code:
     df1.to_csv("newFile.csv", index=None) 
    I hope this helps.

    Regards,
    Sunny
    Sr. Teaching Assistant
     
    #11
    Fasih Ahmed likes this.
  12. SUNNY BHAVEEN CHANDRA

    SUNNY BHAVEEN CHANDRA Active Member

    Joined:
    Feb 4, 2019
    Messages:
    20
    Likes Received:
    2
    Hi Srijith,

    You just need a Gmail account to access the drive whether it is registered on our website or not it doesn't matter.
    I hope this helps.

    Regards,
    Sunny
    Sr. Teaching Assistant
     
    #12
  13. SUNNY BHAVEEN CHANDRA

    SUNNY BHAVEEN CHANDRA Active Member

    Joined:
    Feb 4, 2019
    Messages:
    20
    Likes Received:
    2
    Hi Amit,

    Follow our self-learning course at this URL for python programming -> https://lms.simplilearn.com/#/course/3381-Programming-with-Python-3.X
    Or you can also read the following book -
    Learn Python 3 The Hard Way
    by Zed A.Shaw (Author)


    And most importantly practice is the key! :)

    I hope this will help you.

    Regards,
    Sunny
    Sr. Teaching Assistant
     
    #13
  14. Srijith Kaladharan

    Joined:
    Mar 14, 2019
    Messages:
    3
    Likes Received:
    1

    Thanks Sunny for prompt reply.. I even tried with my gmail account.. But i am getting an access denied prompt.

    Below is the screenshot of the prompt I get when i try to download the file from the drive.
    upload_2019-6-14_20-13-4.png
     
    #14
  15. SUNNY BHAVEEN CHANDRA

    SUNNY BHAVEEN CHANDRA Active Member

    Joined:
    Feb 4, 2019
    Messages:
    20
    Likes Received:
    2
    Hi Srijith,

    Follow these steps -
    1. Press control+shift+N. This will open a new incognito window in chrome. For Firefox its control+shift+P.
    2. Sign in with ur relevant account and it's done.!!! Now use that link. It should work perfectly.

    And I tried this without signing in as well and I was able to access the files. Try at your end and let me know.

    Regards,
    Sunny
    Sr. Teaching Assistant
     
    #15
  16. Fasih Ahmed

    Fasih Ahmed Member

    Joined:
    May 22, 2019
    Messages:
    3
    Likes Received:
    2
    Thank you Sunny. It is working awesome.
     
    #16
    SUNNY BHAVEEN CHANDRA likes this.
  17. Srijith Kaladharan

    Joined:
    Mar 14, 2019
    Messages:
    3
    Likes Received:
    1
    It worked Sunny.. Thanks alot ;)
     
    #17
    SUNNY BHAVEEN CHANDRA likes this.
  18. _54418

    _54418 New Member

    Joined:
    Jan 3, 2019
    Messages:
    1
    Likes Received:
    0
    Can anyone help with anything related to Project 2 last part?
    Project2 (Customer Service Requests Analysis) which is as follows:

    Perform a statistical test for the following:

    Please note: For the below statements you need to state the Null and Alternate and then provide a statistical test to accept or reject the Null Hypothesis along with the corresponding ‘p-value’.

    • Whether the average response time across complaint types is similar or not (overall)
    • Are the type of complaint or service requested and location related?
     
    #18
  19. Sanjib Kumar Ghosh

    Sanjib Kumar Ghosh New Member

    Joined:
    May 27, 2019
    Messages:
    1
    Likes Received:
    0
    Hi Sunny/Kanth
    Due to personal emergency i was not able to join today's class, so i am requesting for the recordings to be sent to me personal email ID tomorrow as an when ti is generated, as i have been registered from back end so did not get the option to download from website.
    I also have raised the ticket for the same.
    Thanks
    Sanjib Ghosh
     
    #19

Share This Page