Friday, November 1, 2019

EDA

EDA On New York Clinic Data/Attendees Data (Project)


EDA: Exploratory Data Analysis.

    First, we import CSV files. To import them, CSV files should be libraries.

How to import CSV file in libraries:
1. Click "+" dropdown, select "From Computer"  to upload file in your library.




2. Now you will be able to read CSV files, by simply writing below commands:

3. To find the name of the column:

4. To put the columns inside the list:

5. To select only two columns:

6. To find data where "month"  is "12/90":

7. To find total no. of all the columns:

8. To find the location of "1/86"  and "market"  to be -0.061134 :



9. Use of Group By:- To group by "market" and cout of "month":




10. To find all the "market" and count of "month" 


11. Melt is used to convert a bunch of columns into single row.



No comments:

Post a Comment