{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":678794128,"defaultBranch":"main","name":"FreeCodeCamp-Data-analysis-with-Python","ownerLogin":"vansh-py04","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2023-08-15T11:51:23.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/128248352?v=4","public":true,"private":false,"isOrgOwned":false},"refInfo":{"name":"","listCacheKey":"v0:1707651640.0","currentOid":""},"activityList":{"items":[{"before":"1f1f22b221f1848f9b83752755a341d645054f1b","after":"7c74d1748f81a608dc8434234e5e674b0aefcd44","ref":"refs/heads/main","pushedAt":"2024-02-11T11:48:16.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"vansh-py04","name":"Yuganter Pratap","path":"/vansh-py04","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/128248352?s=80&v=4"},"commit":{"message":"Update README.md","shortMessageHtmlLink":"Update README.md"}},{"before":"c2eae013765549b1fee790b550dda8335995ca58","after":"1f1f22b221f1848f9b83752755a341d645054f1b","ref":"refs/heads/main","pushedAt":"2024-02-11T11:46:02.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"vansh-py04","name":"Yuganter Pratap","path":"/vansh-py04","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/128248352?s=80&v=4"},"commit":{"message":"Update README.md","shortMessageHtmlLink":"Update README.md"}},{"before":"4d245f80fe16ce2345b367e6718d81f8db4e144f","after":"c2eae013765549b1fee790b550dda8335995ca58","ref":"refs/heads/main","pushedAt":"2024-02-11T11:44:14.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"vansh-py04","name":"Yuganter Pratap","path":"/vansh-py04","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/128248352?s=80&v=4"},"commit":{"message":"Update README.md","shortMessageHtmlLink":"Update README.md"}},{"before":"72569bf168228b672847622f668e9a1cdf90e6bf","after":"4d245f80fe16ce2345b367e6718d81f8db4e144f","ref":"refs/heads/main","pushedAt":"2024-02-11T11:42:12.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"vansh-py04","name":"Yuganter Pratap","path":"/vansh-py04","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/128248352?s=80&v=4"},"commit":{"message":"Create README.md","shortMessageHtmlLink":"Create README.md"}},{"before":"b9968d1da30f5492dd1edb6eb1e4290052a32e0d","after":"72569bf168228b672847622f668e9a1cdf90e6bf","ref":"refs/heads/main","pushedAt":"2024-02-11T11:40:39.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"vansh-py04","name":"Yuganter Pratap","path":"/vansh-py04","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/128248352?s=80&v=4"},"commit":{"message":"Add files via upload","shortMessageHtmlLink":"Add files via upload"}},{"before":"e9e9fcab7aac89ac4825fae78fe5878701764dea","after":"b9968d1da30f5492dd1edb6eb1e4290052a32e0d","ref":"refs/heads/main","pushedAt":"2023-12-06T19:11:08.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"vansh-py04","name":"Yuganter Pratap","path":"/vansh-py04","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/128248352?s=80&v=4"},"commit":{"message":"Create Time_Series_Visualizer.py\n\nAssignment\r\nFor this project you will visualize time series data using a line chart, bar chart, and box plots. You will use Pandas, Matplotlib, and Seaborn to visualize a dataset containing the number of page views each day on the freeCodeCamp.org forum from 2016-05-09 to 2019-12-03. The data visualizations will help you understand the patterns in visits and identify yearly and monthly growth.\r\n\r\nUse the data to complete the following tasks:\r\n\r\nUse Pandas to import the data from \"fcc-forum-pageviews.csv\". Set the index to the \"date\" column.\r\nClean the data by filtering out days when the page views were in the top 2.5% of the dataset or bottom 2.5% of the dataset.\r\nCreate a draw_line_plot function that uses Matplotlib to draw a line chart similar to \"examples/Figure_1.png\". The title should be \"Daily freeCodeCamp Forum Page Views 5/2016-12/2019\". The label on the x axis should be \"Date\" and the label on the y axis should be \"Page Views\".\r\nCreate a draw_bar_plot function that draws a bar chart similar to \"examples/Figure_2.png\". It should show average daily page views for each month grouped by year. The legend should show month labels and have a title of \"Months\". On the chart, the label on the x axis should be \"Years\" and the label on the y axis should be \"Average Page Views\".\r\nCreate a draw_box_plot function that uses Searborn to draw two adjacent box plots similar to \"examples/Figure_3.png\". These box plots should show how the values are distributed within a given year or month and how it compares over time. The title of the first chart should be \"Year-wise Box Plot (Trend)\" and the title of the second chart should be \"Month-wise Box Plot (Seasonality)\". Make sure the month labels on bottom start at \"Jan\" and the x and x axis are labeled correctly.\r\nFor each chart, make sure to use a copy of the data frame. Unit tests are written for you under test_module.py.","shortMessageHtmlLink":"Create Time_Series_Visualizer.py"}},{"before":"721e465cd938b4d41ed8a33d7fa9b3aa370ad4bf","after":"e9e9fcab7aac89ac4825fae78fe5878701764dea","ref":"refs/heads/main","pushedAt":"2023-12-06T19:10:18.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"vansh-py04","name":"Yuganter Pratap","path":"/vansh-py04","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/128248352?s=80&v=4"},"commit":{"message":"Create Sea_Level_Predictor.py\n\nAssignment\r\nYou will anaylize a dataset of the global average sea level change since 1880. You will use the data to predict the sea level change through year 2050.\r\n\r\nUse the data to complete the following tasks:\r\n\r\nUse Pandas to import the data from epa-sea-level.csv.\r\nUse matplotlib to create a scatter plot using the \"Year\" column as the x-axis and the \"CSIRO Adjusted Sea Level\" column as the y-axix.\r\nUse the linregress function from scipi.stats to get the slope and y-intercept of the line of best fit. Plot the line of best fit over the top of the scatter plot. Make the line go through the year 2050 to predict the sea level rise in 2050.\r\nPlot a new line of best fit just using the data from year 2000 through the most recent year in the dataset. Make the line also go through the year 2050 to predict the sea level rise in 2050 if the rate of rise continues as it has since the year 2000.\r\nThe x label should be \"Year\", the y label should be \"Sea Level (inches)\", and the title should be \"Rise in Sea Level\".\r\nUnit tests are written for you under test_module.py.","shortMessageHtmlLink":"Create Sea_Level_Predictor.py"}},{"before":"8c0fafc0eea84b1a090f070422a458a7877ae607","after":"721e465cd938b4d41ed8a33d7fa9b3aa370ad4bf","ref":"refs/heads/main","pushedAt":"2023-12-06T19:09:15.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"vansh-py04","name":"Yuganter Pratap","path":"/vansh-py04","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/128248352?s=80&v=4"},"commit":{"message":"Rename Mean-Variance-Standard Deviation Calculator using Python to Mean-Variance-Standard Deviation Calculator.py","shortMessageHtmlLink":"Rename Mean-Variance-Standard Deviation Calculator using Python to Me…"}},{"before":"a5d1a09653c18b15b8c34d7df3d838f618ac6e93","after":"8c0fafc0eea84b1a090f070422a458a7877ae607","ref":"refs/heads/main","pushedAt":"2023-12-06T19:08:37.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"vansh-py04","name":"Yuganter Pratap","path":"/vansh-py04","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/128248352?s=80&v=4"},"commit":{"message":"Rename DemoGraphic Data Analyzer to DemoGraphic_Data_Analyzer.py","shortMessageHtmlLink":"Rename DemoGraphic Data Analyzer to DemoGraphic_Data_Analyzer.py"}},{"before":"a9631ecf39a170468e51f9c19eaf15eec5674472","after":"a5d1a09653c18b15b8c34d7df3d838f618ac6e93","ref":"refs/heads/main","pushedAt":"2023-12-06T19:07:26.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"vansh-py04","name":"Yuganter Pratap","path":"/vansh-py04","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/128248352?s=80&v=4"},"commit":{"message":"Create Medical_Data_Visualizer.py\n\nAssignment\r\nIn this project, you will visualize and make calculations from medical examination data using matplotlib, seaborn, and pandas. The dataset values were collected during medical examinations.\r\n\r\nData description\r\nThe rows in the dataset represent patiets and the columns represent information like body measurements, results from various blood tests, and lifestyle choices. You will use the dataset to exploring the relationship between cardiac disease, body measurements, blood markers, and lifestyle choices.","shortMessageHtmlLink":"Create Medical_Data_Visualizer.py"}},{"before":"673e23944e07d50df4b58fbf99698b336779bebf","after":"a9631ecf39a170468e51f9c19eaf15eec5674472","ref":"refs/heads/main","pushedAt":"2023-11-07T18:33:06.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"vansh-py04","name":"Yuganter Pratap","path":"/vansh-py04","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/128248352?s=80&v=4"},"commit":{"message":"Delete Bank Loan Study.ipynb","shortMessageHtmlLink":"Delete Bank Loan Study.ipynb"}},{"before":"46bc82159cc016d42f6da11bead65f82a4692bbf","after":"673e23944e07d50df4b58fbf99698b336779bebf","ref":"refs/heads/main","pushedAt":"2023-08-18T09:54:36.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"vansh-py04","name":"Yuganter Pratap","path":"/vansh-py04","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/128248352?s=80&v=4"},"commit":{"message":"Add files via upload\n\nData Cleansing process of Bank Loan Case Study Dataset using Python on Jupyter Notebook","shortMessageHtmlLink":"Add files via upload"}},{"before":"1a9684fc11f649ab5796618cb7858084a680982c","after":"46bc82159cc016d42f6da11bead65f82a4692bbf","ref":"refs/heads/main","pushedAt":"2023-08-18T09:53:25.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"vansh-py04","name":"Yuganter Pratap","path":"/vansh-py04","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/128248352?s=80&v=4"},"commit":{"message":"Delete Instagram User Analytics","shortMessageHtmlLink":"Delete Instagram User Analytics"}},{"before":"5fbd87f8a0a3a71320f65adb0dbd65f794a10ac2","after":"1a9684fc11f649ab5796618cb7858084a680982c","ref":"refs/heads/main","pushedAt":"2023-08-17T08:49:25.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"vansh-py04","name":"Yuganter Pratap","path":"/vansh-py04","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/128248352?s=80&v=4"},"commit":{"message":"Delete Instagram User Analytics.pptx","shortMessageHtmlLink":"Delete Instagram User Analytics.pptx"}},{"before":"6670199c3fa9d6f1463a6ee53b44ea36130810ea","after":"5fbd87f8a0a3a71320f65adb0dbd65f794a10ac2","ref":"refs/heads/main","pushedAt":"2023-08-17T08:46:14.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"vansh-py04","name":"Yuganter Pratap","path":"/vansh-py04","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/128248352?s=80&v=4"},"commit":{"message":"Add files via upload\n\nSQL Fundamentals\r\n\r\nDescription:\r\nImagine you're a data analyst working with the product team at Instagram. Your role involves analyzing user interactions and engagement with the Instagram app to provide valuable insights that can help the business grow.\r\nUser analysis involves tracking how users engage with a digital product, such as a software application or a mobile app. The insights derived from this analysis can be used by various teams within the business. For example, the marketing team might use these insights to launch a new campaign, the product team might use them to decide on new features to build, and the development team might use them to improve the overall user experience.\r\nIn this project, you'll be using SQL and MySQL Workbench as your tool to analyze Instagram user data and answer questions posed by the management team. Your insights will help the product manager and the rest of the team make informed decisions about the future direction of the Instagram app.\r\nRemember, the goal of this project is to use your SQL skills to extract meaningful insights from the data. Your findings could potentially influence the future development of one of the world's most popular social media platforms.\r\n\r\nSQL Tasks :\r\nA) Marketing Analysis:\r\n\r\n1. Loyal User Reward: The marketing team wants to reward the most loyal users, i.e., those who have been using the platform for the longest time.\r\nYour Task: Identify the five oldest users on Instagram from the provided database.\r\n\r\n2. Inactive User Engagement: The team wants to encourage inactive users to start posting by sending them promotional emails.\r\nYour Task: Identify users who have never posted a single photo on Instagram.\r\n\r\n3. Contest Winner Declaration: The team has organized a contest where the user with the most likes on a single photo wins.\r\nYour Task: Determine the winner of the contest and provide their details to the team.\r\n\r\n4. Hashtag Research: A partner brand wants to know the most popular hashtags to use in their posts to reach the most people.\r\nYour Task: Identify and suggest the top five most commonly used hashtags on the platform.\r\n\r\n5. Ad Campaign Launch: The team wants to know the best day of the week to launch ads.\r\nYour Task: Determine the day of the week when most users register on Instagram. Provide insights on when to schedule an ad campaign.\r\n\r\nB) Investor Metrics:\r\n\r\n1. User Engagement: Investors want to know if users are still active and posting on Instagram or if they are making fewer posts.\r\nYour Task: Calculate the average number of posts per user on Instagram. Also, provide the total number of photos on Instagram divided by the total number of users.\r\n\r\n2. Bots & Fake Accounts: Investors want to know if the platform is crowded with fake and dummy accounts.\r\nYour Task: Identify users (potential bots) who have liked every single photo on the site, as this is not typically possible for a normal user.","shortMessageHtmlLink":"Add files via upload"}},{"before":"68db57fd3fd68d161244cf40fd0b7ec7f1d830f9","after":"6670199c3fa9d6f1463a6ee53b44ea36130810ea","ref":"refs/heads/main","pushedAt":"2023-08-17T08:44:46.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"vansh-py04","name":"Yuganter Pratap","path":"/vansh-py04","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/128248352?s=80&v=4"},"commit":{"message":"Instagram User Analytics\n\nImagine you're a data analyst working with the product team at Instagram. Your role involves analyzing user interactions and engagement with the Instagram app to provide valuable insights that can help the business grow.\r\nUser analysis involves tracking how users engage with a digital product, such as a software application or a mobile app. The insights derived from this analysis can be used by various teams within the business. For example, the marketing team might use these insights to launch a new campaign, the product team might use them to decide on new features to build, and the development team might use them to improve the overall user experience.\r\nIn this project, you'll be using SQL and MySQL Workbench as your tool to analyze Instagram user data and answer questions posed by the management team. Your insights will help the product manager and the rest of the team make informed decisions about the future direction of the Instagram app.\r\nRemember, the goal of this project is to use your SQL skills to extract meaningful insights from the data. Your findings could potentially influence the future development of one of the world's most popular social media platforms","shortMessageHtmlLink":"Instagram User Analytics"}},{"before":"751ed0891ee6346e4e31b3e10d0ad36eaa854c39","after":"68db57fd3fd68d161244cf40fd0b7ec7f1d830f9","ref":"refs/heads/main","pushedAt":"2023-08-15T16:33:45.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"vansh-py04","name":"Yuganter Pratap","path":"/vansh-py04","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/128248352?s=80&v=4"},"commit":{"message":"DemoGraphic Data Analyzer\n\nIn this challenge you must analyze demographic data using Pandas. You are given a dataset of demographic data that was extracted from the 1994 Census database. Here is a sample of what the data looks like:\r\n\r\n|    |   age | workclass        |   fnlwgt | education   |   education-num | marital-status     | occupation        | relationship   | race   | sex    |   capital-gain |   capital-loss |   hours-per-week | native-country   | salary   |\r\n|---:|------:|:-----------------|---------:|:------------|----------------:|:-------------------|:------------------|:---------------|:-------|:-------|---------------:|---------------:|-----------------:|:-----------------|:---------|\r\n|  0 |    39 | State-gov        |    77516 | Bachelors   |              13 | Never-married      | Adm-clerical      | Not-in-family  | White  | Male   |           2174 |              0 |               40 | United-States    | <=50K    |\r\n|  1 |    50 | Self-emp-not-inc |    83311 | Bachelors   |              13 | Married-civ-spouse | Exec-managerial   | Husband        | White  | Male   |              0 |              0 |               13 | United-States    | <=50K    |\r\n|  2 |    38 | Private          |   215646 | HS-grad     |               9 | Divorced           | Handlers-cleaners | Not-in-family  | White  | Male   |              0 |              0 |               40 | United-States    | <=50K    |\r\n|  3 |    53 | Private          |   234721 | 11th        |               7 | Married-civ-spouse | Handlers-cleaners | Husband        | Black  | Male   |              0 |              0 |               40 | United-States    | <=50K    |\r\n|  4 |    28 | Private          |   338409 | Bachelors   |              13 | Married-civ-spouse | Prof-specialty    | Wife           | Black  | Female |              0 |              0 |               40 | Cuba             | <=50K    |\r\nYou must use Pandas to answer the following questions:\r\n\r\nHow many people of each race are represented in this dataset? This should be a Pandas series with race names as the index labels. (race column)\r\nWhat is the average age of men?\r\nWhat is the percentage of people who have a Bachelor's degree?\r\nWhat percentage of people with advanced education (Bachelors, Masters, or Doctorate) make more than 50K?\r\nWhat percentage of people without advanced education make more than 50K?\r\nWhat is the minimum number of hours a person works per week?\r\nWhat percentage of the people who work the minimum number of hours per week have a salary of more than 50K?\r\nWhat country has the highest percentage of people that earn >50K and what is that percentage?\r\nIdentify the most popular occupation for those who earn >50K in India.","shortMessageHtmlLink":"DemoGraphic Data Analyzer"}},{"before":null,"after":"751ed0891ee6346e4e31b3e10d0ad36eaa854c39","ref":"refs/heads/main","pushedAt":"2023-08-15T11:53:30.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"vansh-py04","name":"Yuganter Pratap","path":"/vansh-py04","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/128248352?s=80&v=4"},"commit":{"message":"Mean-Variance-Standard Deviation Calculator using Python\n\nCreate a function named calculate() in mean_var_std.py that uses Numpy to output the mean, variance, standard deviation, max, min, and sum of the rows, columns, and elements in a 3 x 3 matrix.\r\n\r\nThe input of the function should be a list containing 9 digits. The function should convert the list into a 3 x 3 Numpy array, and then return a dictionary containing the mean, variance, standard deviation, max, min, and sum along both axes and for the flattened matrix.\r\n\r\nThe returned dictionary should follow this format:\r\n\r\n{\r\n  'mean': [axis1, axis2, flattened],\r\n  'variance': [axis1, axis2, flattened],\r\n  'standard deviation': [axis1, axis2, flattened],\r\n  'max': [axis1, axis2, flattened],\r\n  'min': [axis1, axis2, flattened],\r\n  'sum': [axis1, axis2, flattened]\r\n}\r\nIf a list containing less than 9 elements is passed into the function, it should raise a ValueError exception with the message: \"List must contain nine numbers.\" The values in the returned dictionary should be lists and not Numpy arrays.\r\n\r\nFor example, calculate([0,1,2,3,4,5,6,7,8]) should return:\r\n\r\n{\r\n  'mean': [[3.0, 4.0, 5.0], [1.0, 4.0, 7.0], 4.0],\r\n  'variance': [[6.0, 6.0, 6.0], [0.6666666666666666, 0.6666666666666666, 0.6666666666666666], 6.666666666666667],\r\n  'standard deviation': [[2.449489742783178, 2.449489742783178, 2.449489742783178], [0.816496580927726, 0.816496580927726, 0.816496580927726], 2.581988897471611],\r\n  'max': [[6, 7, 8], [2, 5, 8], 8],\r\n  'min': [[0, 1, 2], [0, 3, 6], 0],\r\n  'sum': [[9, 12, 15], [3, 12, 21], 36]\r\n}","shortMessageHtmlLink":"Mean-Variance-Standard Deviation Calculator using Python"}}],"hasNextPage":false,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAD97ArZgA","startCursor":null,"endCursor":null}},"title":"Activity · vansh-py04/FreeCodeCamp-Data-analysis-with-Python"}