I will excel data wrangling, editing, cleaning, formatting

Egypt

I speak English, Arabic

Data Scientist specializing in data analysis and visualization

My name is Mark Fahim, a data scientist with over 18 months of experience in machine learning and data analysis. At ALX, I developed KPIs and transformed complex data into actionable insights. My expe...

About this Gig

The Gig should be performed in two steps as follows:

Removing duplicate entries:

Removing duplicate entries, handling missing values (deleting or imputing), correcting spelling and formatting errors, removing extra spaces and trimming text, handling outliers, removing unnecessary columns or rows, handling special characters or symbols, text-to-columns (splitting data based on delimiters), removing hidden characters or formatting, consolidating data from multiple worksheets or workbooks, using Power Query for advanced data transformation.

Data Formatting:

Standardizing data formats (e.g., dates, numbers, text), converting data types (e.g., text to numbers), normalizing or scaling numerical data, applying consistent capitalization, standardizing units of measurement, applying data validation rules, creating drop-down lists for data entry standardization, applying custom number formats, creating and applying named ranges, applying data encryption or protection, implementing data validation with custom rules, applying conditional formatting with formulas.