PinnedAparna Mishra·Jan 26, 2023Pandas 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.
PinnedAparna Mishra·Dec 6, 2021Groupby PandasA groupby operation involves grouping of categorical columns, applying a function, and combining the results. This can be used to group…
PinnedAparna Mishra·Apr 30, 202218 Important functions in PandasData processing is an important part of analyzing data. This includes various tasks like cleaning, restructuring, merging, removing…A response icon4A response icon4
PinnedAparna Mishra·Oct 30, 2022How 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…
PinnedAparna Mishra·Nov 13, 2022Automate Excel Pivot Table with Python using pywin32In this story I will demonstrate how to automate excel pivot table creation using python pywin32.A response icon2A response icon2
Aparna Mishra·Oct 30, 2022How 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…
Aparna Mishra·Aug 17, 2022SQL IdentityA SQL identity column is a column whose values are generated automatically when a new row is added to the table.
Aparna Mishra·Aug 16, 2022How 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.
Aparna Mishra·Aug 4, 2022SQL JoinsSQL Join statements are used to combine data or rows from two or more tables based on a common field between them.
Aparna Mishra·Aug 3, 2022Scraping 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.