DATA CLEANING
Data cleaning is the process of fixing or removing
incorrect, corrupted, incorrectly formatted, duplicate, or incomplete data
within a dataset.
Shortcuts for Data Cleaning
1- Ctrl + Spacebar = select current column
2- Ctrl+shift+down=select only work column text
3- Ctrl+shift+ =Insert new column
4- Ctrl - = delete new column
5- Alt+H+P=Percentage
6- Substitute(N3,",",".")
7- Ctrl+Minus(Show row,column panel)
8- Alt+H+O+A To autofit rows
8- Data+Filter+Blank Rowa+Ctrl+-
9- Ctrl+G+Special+Blanks+=select top cell+Ctrl+Enter
10- Select Column+Ctrl+G+Blanks+Type NA+Ctrl+Enter
11- Select Column+Ctrl+H+Find what(Ctrl+J)+Replace with(press space bar)+Replace All
12- =IFERROR(H6/G6,"")
13- */
14- .*
DATA MINING
Data mining is the process of extracting useful insights and patterns from large datasets.
ABOUT CSV (COMMA-SEPARATED
VALUES) FILES
A CSV is a comma-separated values file, which allows data to be saved in a tabular format.
A CSV file is a list of data separated by commas. For instance, it may look like the following: Name, email, phone number, address. Example,example@example.com,555-555-5555, Example Address.
👉Data Cleaning & CSV Files Assignments
EXAMPLES
OF CLEANING DATA ON FIVERR
FIVER GIG (Excel Data Cleaning)
Click Here: Excel Data Cleaning and Formatting
Gig Title: I will tidy up, organize,
format, combine, separate, and sort Excel or CSV data for you.
Tags & Key Words:
Data Cleaning
Excel Organization
CSV Formatting
Data Sorting
Spreadsheet Management
About GIG:
Get your data in top shape with my gig! I'll clean,
organize, and format Excel or CSV files for you, making your information neat
and easy to use.
I can help you with:
- Making
Excel data clean and neat
- Sorting,
organizing, and cleaning data
- Entering,
analyzing, and managing data
- Collecting
and sorting information
- Using
Google Spreadsheets
- Detecting
errors
- Separating
or combining names and addresses
- Formatting
CSV files for uploading
- Changing
data from rows to columns and vice versa
- Fixing
'Date' formatting issues
- Rearranging
Excel data as you need.
What's included in this service?
1.
Excel Data Enhancement
2.
Comprehensive Data
Management
3.
Data Entry and Analysis
4.
Efficient Sorting and
Collection
5.
Customized Excel Solutions
Don't stress about data tasks; I'm here to make it simple
for you. Let's work together to make your data work for you. Contact me today to
get started!
Looking forward to working with you!
Sincerely,
Farzana Hussain
Compare packages
|
Package |
PKR 3,475 BASIC |
PKR 5,458 STANDARD |
PKR 9,897 PREMIUM |
|
Do Excel data cleaning, organizing, merging, and formatting ( 500
rows ) in multiple sheets |
Do Excel data cleaning, organizing, merging, and formatting ( 1500
rows ) in multiple sheets |
Do Excel data cleaning, organizing, merging, and formatting ( 3000
rows ) in multiple sheets |
|
|
Items Cleaned |
100 |
1,500 |
3,000 |
|
Revisions |
Unlimited |
Unlimited |
Unlimited |
|
Delivery Time |
1 day |
2 day |
5 days |
Description & FAQ
Add a question
·
Provide a brief overview of
the project and its objectives
·
List the specific tasks
·
Mention any specific
deadlines or timeframes for each task or the overall project
·
provide any content,
materials, or resources
·
Clarify the number of
revisions you expect for each task or deliverable
Create Awesome Videos from Your Photos for GIGS