Posts

Showing posts with the label excel

Featured Post

How to Work With Tuple in Python

Image
Tuple in python is one of the streaming datasets. The other streaming datasets are List and Dictionary. Operations that you can perform on it are shown here for your reference. Writing tuple is easy. It has values of comma separated, and enclosed with parenthesis '()'. The values in the tuple are immutable, which means you cannot replace with new values. #1. How to create a tuple Code: my_tuple=(1,2,3,4,5) print(my_tuple) Output: (1, 2, 3, 4, 5) ** Process exited - Return Code: 0 ** Press Enter to exit terminal #2. How to read tuple values Code: print(my_tuple[0]) Output: 1 ** Process exited - Return Code: 0 ** Press Enter to exit terminal #3. How to add two tuples Code: a=(1,6,7,8) c=(3,4,5,6,7,8) d=print(a+c) Output: (1, 6, 7, 8, 3, 4, 5, 6, 7, 8) ** Process exited - Return Code: 0 ** Press Enter to exit terminal #4.  How to count tuple values Here the count is not counting values; count the repetition of a given value. Code: sample=(1, 6, 7, 8, 3, 4, 5, 6, 7, 8) print(sample

Course Topics You Need to Know Before You Take Course on Excel

Hey, you want to be master in Excel. There are 4 parts in this course. These contents cover all the functionalities you need to work with Excel. Excel is one of the tools to be used in data analytics Why I have given contents means these you must ask your tutor if present in the course or not. This list useful to start a career in analytics. List of Excel Course Topics Part-1 - Importing Data from other sources Import or Export data from multiple data sources Part-2 - Converting data Excel ready Formatting the data understand by EXCEL. Part-3 - Data Mining Formulas you need for Data cleaning. Part-4- Excel Data Analysis Tools Data analysis using statistical methods, Charts and Pivot Tables