Python + NumPy + Pandas — Essential Internship
Topics
A focused roadmap for a Data Analyst internship — only the skills that are genuinely useful for analysis, data
cleaning and portfolio projects.
Goal: Use Python to load, clean, explore, transform and analyze real datasets confidently, mainly with NumPy and Pandas.
1. Python Fundamentals — Must Know
■ Variables and assignment
■ Numbers, strings, booleans and None
■ Lists, tuples, sets and dictionaries
■ Indexing and slicing
■ if / elif / else
■ for and while loops
■ range()
■ Functions: def, parameters, return
■ Default and keyword arguments
■ List and dictionary comprehensions
■ Basic string methods
■ Basic built-in functions: len, sum, min, max, sorted, round
■ Importing and using modules
■ Basic exception handling with try/except
2. NumPy — Essential for Data Analysis
■ Understand what NumPy arrays are and why they are useful.
■ Create arrays with [Link], arange and linspace.
■ Understand shape, size, ndim and dtype.
■ Indexing and slicing arrays.
■ Boolean/conditional filtering.
■ Reshape arrays with reshape.
■ Understand rows, columns and axis.
■ Vectorized operations instead of unnecessary Python loops.
■ Basic arithmetic operations on arrays.
■ Aggregation: sum, mean, median, min, max, std, var.
■ Basic handling of NaN values.
■ Random number generation at a basic level.
3. Pandas Fundamentals
■ Understand Series vs DataFrame.
■ Create DataFrames and inspect their structure.
■ Read CSV and Excel files.
■ Understand head(), tail(), shape, columns, dtypes and info().
■ Use describe() for quick statistical summaries.
■ Select columns and rows.
■ loc and iloc.
■ Filter rows using conditions.
■ Sort values.
■ Rename columns.
■ Add, modify and remove columns.
■ Set and reset index when appropriate.
4. Pandas Data Cleaning — Very Important
■ Detect missing values with isna() / isnull().
■ Handle missing values with fillna() and dropna().
■ Detect and remove duplicates.
■ Handle incorrect data types with astype() and to_datetime().
■ Clean text using str methods.
■ Replace inconsistent categories.
■ Handle outliers at a basic analytical level.
■ Find and investigate invalid values.
■ Create clean, analysis-ready columns.
5. Pandas Grouping & Aggregation — Must Know
■ groupby().
■ sum, mean, median, count, min, max, std.
■ Multiple aggregations with agg().
■ Grouping by multiple columns.
■ Filtering grouped results.
■ value_counts().
■ nunique().
■ Transform grouped values with transform() when needed.
6. Combining Data — Must Know
■ merge() for joining DataFrames.
■ Understand inner, left, right and outer joins.
■ Merge using one or multiple keys.
■ concat() for stacking DataFrames.
■ Understand merge vs concat.
■ Basic join concepts.
■ Check row counts after a merge to catch accidental duplication.
7. Reshaping & Analysis
■ pivot_table().
■ pivot() at a basic level.
■ melt() for converting wide data to long format.
■ sort_values().
■ rank() at a basic level.
■ cumsum() for cumulative analysis.
■ rolling() for basic rolling calculations.
■ Create calculated/derived columns.
8. Dates & Time Series — Important
■ Convert columns using pd.to_datetime().
■ Extract year, month, day and weekday.
■ Filter data by dates.
■ Sort by dates.
■ Resample basic time-series data.
■ Create monthly/yearly summaries.
■ Calculate basic period-over-period changes.
9. Exploratory Data Analysis (EDA)
■ Understand the dataset before analysis.
■ Check shape, columns, data types and missing values.
■ Calculate descriptive statistics.
■ Analyze distributions.
■ Find duplicates and unusual values.
■ Compare groups using aggregation.
■ Identify trends and patterns.
■ Calculate correlations.
■ Use basic visualizations to support analysis.
■ Turn EDA findings into business insights.
10. Basic Visualization for Analysts
■ Matplotlib basics.
■ Line charts.
■ Bar charts.
■ Histograms.
■ Scatter plots.
■ Boxplots.
■ Labels, titles and readable axes.
■ Choose a chart based on the analytical question.
11. Practical Data Analyst Workflow
■ ■ Load raw data.
■ ■ Inspect the data.
■ ■ Check data types and missing values.
■ ■ Clean and standardize the data.
■ ■ Remove duplicates and investigate anomalies.
■ ■ Create useful derived columns.
■ ■ Explore the data with groupby and statistics.
■ ■ Analyze trends and relationships.
■ ■ Visualize important findings.
■ ■ Write clear business conclusions.
■ ■ Export the cleaned/processed dataset when required.
12. Portfolio — Python/Pandas Resume Skills
■ Build 2–3 focused data-analysis projects.
■ Use real or realistic messy datasets.
■ Show the complete workflow: cleaning → EDA → analysis → visualization → insights.
■ Use Pandas heavily rather than only showing basic Python syntax.
■ Include at least one project using merge/groupby/pivot_table/time analysis.
■ Document the business question and key findings.
■ Keep notebooks organized with clear sections and explanations.
■ Upload projects to GitHub with a useful README.
13. Essential Interview Topics
■ List vs tuple vs set vs dictionary.
■ What is a function and why use one?
■ List comprehension.
■ NumPy array vs Python list.
■ What is vectorization?
■ Shape and axis in NumPy.
■ Series vs DataFrame.
■ loc vs iloc.
■ How to handle missing values in Pandas.
■ How to remove duplicates.
■ groupby and aggregation.
■ merge vs concat.
■ inner vs left join.
■ apply vs vectorized Pandas operations at a practical level.
■ pivot_table.
■ How to perform basic EDA.
■ How you would investigate a messy dataset.
Recommended Learning Order
Order Topic Priority
1 Python fundamentals Essential
2 NumPy basics Essential
3 Pandas fundamentals Essential
4 Pandas data cleaning Essential
5 groupby + aggregation Essential
6 merge + concat Essential
7 Reshaping + dates Important
8 EDA + visualization Essential
9 2–3 portfolio projects Essential
10 Interview practice Essential
Not necessary initially
Advanced OOP, decorators, generators, web development, Django/Flask, advanced NumPy internals, machine learning, complex
software architecture and other software-engineering topics are intentionally excluded. Learn them later if your career requires
them.
Internship target: Become very comfortable with Python basics + NumPy fundamentals + Pandas data cleaning, transformation,
aggregation and analysis.