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.Jan 26, 2023Jan 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…Dec 6, 2021Dec 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…Apr 30, 20224Apr 30, 20224
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…Oct 30, 2022Oct 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.Nov 13, 20221Nov 13, 20221
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…Oct 30, 2022Oct 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.Aug 17, 2022Aug 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.Aug 16, 2022Aug 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.Aug 4, 2022Aug 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.Aug 3, 2022Aug 3, 2022