Python Programming

Articles

FastAPI Streaming Response: Error: Did not receive done or success response in stream

2024-07-03

Geoanalytics with geopandas and ABS Public Data in Python

2024-04-06

GenAI: Generate SQL from Text via Ollama Python Library on Local

2024-03-24

Pandas DataFrame aggregate a list column to a set

This code snippet shows you how to group a pandas DataFrame and then aggregate a column with list or array type to a set (with duplicates removed) or a list. To implement it, we can first expode the column (list type) and then use groupby to create a grouped DataFrame and then aggregate using set or list or a combination of both. Input `` category users 0 A [1, 2] 1 B [3, 4] 2 C [5, 6, 7] 3 A [1, 8, 1] 4 B [1, 6, 9] ` Output ` category usersset userslist 0 A {8, 1, 2} [8, 1, 2] 1 B {1, 3, 4, 6, 9} [1, 3, 4, 6, 9] 2 C {5, 6, 7} [5, 6, 7] ``

2023-08-10

Azure App Service IIS Log Analytics using Pandas

2022-09-05

Python: Read Data from MS Access Database via ODBC

2022-07-09

Python: Read Data from Oracle Database

2022-06-05

Pandas DataFrame Plot Heatmap using Seaborn

2022-06-04

Torchvision error: Could not find module image.pyd

2021-12-30

Create Environments with Different Python Versions in Anaconda

2021-12-30

Call SQL Server Stored Procedure in Python

2021-12-23

Read Email from Microsoft 365 via Microsoft Graph API

In article Python: Send Email via Microsoft Graph API, I provided detailed steps to send email through msal package. In this article, I am going to show you how to read emails from Microsoft 365 via Microsoft Graph API.

2021-10-18

Python: Send Email via Microsoft Graph API

2021-09-11

Python: Load Data from MySQL

2021-01-23

Load Microsoft 365 SharePoint List Data in Python

2020-09-14

Read and Write XML Files with Python

2020-09-08

Python: Load / Read Multiline CSV File

2020-05-02

Create, Insert, Delete, Update Operations on Teradata via JDBC in Python

2020-04-22

Pandas Read from SQLite Database

2020-04-16

Python: Read Data from SQLite via JDBC

2020-04-10

Data Operations with SQLite Database via Python

2020-04-10

AttributeError: type object 'java.sql.Types' has no attribute '__javaclass__'

2020-04-10