PinnedAparna MishraPandas Concepts That You Should Know in Python(compilation)In this article, I’ll explain how I recently used pandas, which you might come across as a data science professional.4 min read·Jan 26, 2023----
PinnedAparna MishraGroupby PandasA groupby operation involves grouping of categorical columns, applying a function, and combining the results. This can be used to group…2 min read·Dec 6, 2021----
PinnedAparna Mishra18 Important functions in PandasData processing is an important part of analyzing data. This includes various tasks like cleaning, restructuring, merging, removing…11 min read·Apr 30, 2022--4--4
PinnedAparna MishraHow to convert .xls files to .xlsx files in python (code)I was working on an automation project where we were building Python code to automate a team’s manual report generating activities. This…1 min read·Oct 30, 2022----
PinnedAparna MishraAutomate Excel Pivot Table with Python using pywin32In this story I will demonstrate how to automate excel pivot table creation using python pywin32.3 min read·Nov 13, 2022--1--1
Aparna MishraHow to collate multiple excel files into one excel file using python (code)In this story, I’ll explain how to combine numerous Excel files into a single file. A data science practitioner may frequently encounter…1 min read·Oct 30, 2022----
Aparna MishraSQL IdentityA SQL identity column is a column whose values are generated automatically when a new row is added to the table.2 min read·Aug 17, 2022----
Aparna MishraHow to import data into SQL Tables ?This will be a brief explanation of how to import data from a csv or text file using a SQL query.3 min read·Aug 16, 2022----
Aparna MishraSQL JoinsSQL Join statements are used to combine data or rows from two or more tables based on a common field between them.2 min read·Aug 4, 2022----
Aparna MishraScraping Data from Website to Excel sheetIn this short story I will demonstrate how we can scrape data from website into excel worksheet, using “From Web” in the “Data” tab.3 min read·Aug 3, 2022----