Data Analyst

  LinkedIn About Us Section for a Data Analyst Data Analyst | Analytical Thinker | Problem Solver 🔍 About Me: I am a passionate and results-driven Data Analyst with a strong foundation in data analysis and a keen eye for detail. My journey in the world of data began with a 6-month internship where I honed my analytical skills, and I have since continued to thrive in the field as a Data Analyst. 👨‍💼 Professional Experience: In my current role as a Data Analyst, I work diligently to transform raw data into actionable insights that drive informed decision-making. I excel in data collection, cleaning, and visualization, using various tools and methodologies to extract meaningful information from complex datasets. 🔢 Skills: Data Cleaning & Preparation Data Visualization (Tableau, Power BI) Statistical Analysis (R, Python) SQL Database Management Excel Proficiency (Advanced) Problem-Solving & Critical Thinking 🌐 Education: I hold a degree in [Your Degree] from [Your Universi...

1.  Which function in Excel helps in finding out how many numerical entries are there? Count  2. A feature that displays data on a column according to specific criteria? Filter  4. Which data type will be placed on the left comer side of the cell? Text - left,  number - right,  error-free middle  5. Which data type will be placed on the right corner side of the cell? Right - numeric    7.What is the name of the intersection of a column and a row on worksheet?  Cell 8.What type of chart is useful in comparing values versus categories? column chart  9. What function displays row data in a column or column data in a row? Transpose 10. How are data organized in Excel spreadsheet?         a) Rows and Columns 12. A function inside another function is called? a) Nested Function 13. Which of the following functions cannot be used to edit the content of a cell? b) Pressing Ese key 14. To copy cell cont...

Logistic Regression on Coronary Heart Disease data: # Importing the required library import pandas as pd # Importing the dataset chd = pd.read_csv("datasets/chd_data.csv") # Printing the first 5 rows chd.head() # Importing the required library import matplotlib.pyplot as plt %matplotlib inline # Plotting the 'chd' values against 'age' values plt.scatter("age","chd",data=chd) plt.xlabel("age") plt.ylabel("chd") plt.title("Age vs. Coronary Heart Disease")

Create Reports using Pandas Profiling in Python

# for loop fruits = ["apple","banana","cherry","watermelon"] for x in fruits: print(x) # while loop a= 1 while(a<10):      print(a)      a+=2

8. How to get the items of series A not present in series B? import pandas as pd A = pd.Series([10,20,30,40,50]) B = pd.Series([10,100,20,200,80]) print(A[~A. isin(B)]) Bitwise not operators  isin() method is used to filter data frames