Hi,I am doing project NYC 311 Service Request Ana...

Discussion in 'General Discussions' started by _10157, Dec 5, 2017.

  1. _10157

    _10157 Member

    Joined:
    Jul 24, 2017
    Messages:
    4
    Likes Received:
    1
    Hi,
    I am doing project NYC 311 Service Request Analysis. Please help me with solutions of the below questions:
    o Display the complaint type and city together
    o Plot a bar graph of count vs. complaint types
    o Display the major complaint types and their count
     
    #1
    _64218 likes this.
  2. K Manoj

    K Manoj Moderator
    Staff Member Simplilearn Support

    Joined:
    Aug 4, 2017
    Messages:
    237
    Likes Received:
    24
    Ask for hints, not for the solution.
    I will help you with the second one. Figure out the rest :)

    NYC 311.JPG
     
    #2
    Anil Kumar Rudraraju likes this.
  3. _10157

    _10157 Member

    Joined:
    Jul 24, 2017
    Messages:
    4
    Likes Received:
    1
    can you help me with the first one.
     
    #3
  4. K Manoj

    K Manoj Moderator
    Staff Member Simplilearn Support

    Joined:
    Aug 4, 2017
    Messages:
    237
    Likes Received:
    24
    Try creating a data frame which counts and does a groupby (complaint type, city).
    Then create a graph for this.
     
    #4
  5. Pranav Katare

    Pranav Katare Member

    Joined:
    Sep 11, 2017
    Messages:
    5
    Likes Received:
    0
    Here does City means "Incident Address"? coz there is no column as City.
     
    #5
  6. K Manoj

    K Manoj Moderator
    Staff Member Simplilearn Support

    Joined:
    Aug 4, 2017
    Messages:
    237
    Likes Received:
    24
    Code:
    print df_NYC.columns.values. 
    Try this. See if you can find the column city.
     
    #6
  7. Rahul Somani

    Rahul Somani Member

    Joined:
    May 19, 2017
    Messages:
    2
    Likes Received:
    0
    IN NYC 311 project documentation:-

    Basic data exploratory analysis
    o Explore data
    o Find patterns --- ?? --> What type of patterns you are looking forward for. It's unclear
    o Display the complaint type and city together
     
    #7
  8. Priyanka_Mehta

    Priyanka_Mehta Well-Known Member
    Simplilearn Support

    Joined:
    May 25, 2017
    Messages:
    868
    Likes Received:
    59
    Hi Rahul,

    I would like to inform you that, Find Patterns - you have to find the patterns on the basis of complaint Type. So, you have to get the list of the complaint type and its count and then sort the count on the basis of value.

    Also, Kindly find the link mentioned below to download the recording where guidance for the said project is given.
    https://simplilearnsolutions.webex....ldr.php?RCID=78aba8206333eb1648b510f00fb33d79

    I hope this will help you.
     
    #8
  9. Ritwik Bijalwan

    Joined:
    Jul 5, 2019
    Messages:
    3
    Likes Received:
    0
    Regarding NYC 311 project :-
    How would i convert the string value for Created Date and Closed Date into datetime object
    NOTE->whenever i try to use datetime module it is either giving Value error or positional argument error
     
    #9
  10. Ramanpreet kaur

    Joined:
    Jul 25, 2019
    Messages:
    3
    Likes Received:
    0
    #10

Share This Page