PinnedR. GuptainPython in Plain EnglishPart 1: Solve SQL Problems Asked by Product-Based CompaniesQuestion: Average session time asked by FacebookSep 8, 2022Sep 8, 2022
PinnedR. GuptainPython in Plain EnglishAll About Decorators in PythonThere is a unique feature which is named decorators. In simplest analogy, the decorator is the process of decorating an existing thing…Aug 30, 2022Aug 30, 2022
PinnedR. GuptainPython in Plain English5 Short Tricks of PostgreSQL That You Must Know for Manipulation of DataPostgreSQL tricks for copying the existing table into a new table based on different conditions.Jun 7, 2022Jun 7, 2022
PinnedR. GuptainPython in Plain EnglishWhy You Should Use Pyenv & Poetry for Python ProjectsA guide on how to create a new Python Poetry project in combination with pyenv and how to add Poetry to an existing project.Apr 25, 20221Apr 25, 20221
PinnedR. GuptainPython in Plain EnglishMeet Pandas-Profiling: A Python Library for Data AnalysisHow to use pandas-profiling for data analysisApr 20, 2022Apr 20, 2022
R. GuptainPython in Plain EnglishExploring the GitHub GraphQL API: Authentication, Queries, Mutations, Pagination, and Rate LimitsGithub provides APIs to interact with Github server’s data. APIs are provided in two variants: REST API, and GraphQL API. In this article…Jun 17Jun 17
R. GuptainPython in Plain EnglishA Comparative Analysis of Paramiko, PySFTP, and SFTPpretty for SFTP Server Access in PythonSecure File Transfer Protocol (SFTP) is a widely used protocol for securely transferring files over a network. In Python, several libraries…Jan 17Jan 17
R. GuptainPython in Plain EnglishDjango Middleware: A Beginner’s to Intermediate GuideDjango middleware is a framework of hooks that allows you to modify the request and response objects during the processing of a web…Aug 1, 2023Aug 1, 2023
R. GuptainGeek CultureMastering GroupBy Aggregation in Pandas: Using Different Aggregated Functions on Different Columns…GroupBy is a powerful tool in Pandas that allows you to group your data based on a specific criterion and apply some aggregation functions…May 16, 2023May 16, 2023
R. GuptainPython in Plain EnglishMastering Data Summarization with Pivot Tables in PandasIn data analysis and data science, one of the most important tasks is to summarize and aggregate data to extract insights and patterns. A…May 15, 20231May 15, 20231