xlwings (Open Source) is a BSD-licensed Python library that makes it easy to call Python from Excel and vice versa. Numpy arrays and Pandas Series/DataFrames are fully supported. xlwings-powered workbooks are easy to distribute and work on Windows and Mac. xlwings is only compatible with Windows and macOS because it requires the installation of Excel. UDFs (User Defined Functions) are presently not supported […]
Pandas Introduction in Python
Pandas is a Python library that provides quick, versatile, and expressive data structures for working with “relational” or “labelled” data. Its goal is to serve as the foundation for undertaking realistic, real-world data analysis in Python. Pandas is an open source Python package that is most widely used for data science/data analysis and machine learning […]
Configure NGINX to Run Django App in a Sub Path
Sometimes we need to run our Django project in sub path of parent URL ( www.yourmainurl.com/yourproject ) and when I have this situation I researched a lot and finally found my solution. Here I have tried to solve your problem. In this post we will learn how to configure NGINX to run your Django project. […]
Generate Setup File for Windows Application in visual Studio 2022
This is the most significant instruction for making a Setup File (.exe) from a Windows Forms application. It is simple to install on any Windows PC. It is only compatible with the Windows operating system. Now I’ll convert these Windows Forms applications to Setup Files. To build a setup file from a Windows Forms application, […]
How to Connect With MySQL Database in Visual Studio 2022
In this post we will learn how to connect with MySQL database in Visual Studio 2022. To connect with MySQL we have to install MySql.Data package from NuGet Packages. First Go to Tools Menu and select NuGet Package Manager > Manage NuGet Packages for Solutions.. Then Go to Browse tab and in the search box […]
How to Enable Report Viewer in Visual Studio 2022
In this post we will learn how to enable Report Viewer in visual studio 2022. To enable RDLC you have to install 2 extensions: Microsoft RDLC Designer Microsoft Reporting Service Project Go to the Extensions menu and select Manage Extensions. To install package search RDLC in Manage Extensions. This is going to be our first […]
Setup Crontab in Django Project
The crontab could be a list of commands simply need to run on a regular schedule, and also the name of the command used to manage that list. cron is the system process which will automatically perform tasks for you according to a set schedule. The schedule is called the crontab, which is also the name of the program used to edit […]
Upload image into custom folder in Django
Today we are going to upload image using django model. We’re going to create a small project where we can implement Django’s file upload, save and view functions, with a database but where the images will be stored on a hard drive. We assuming that you already configured your project. If you want to know […]
Python Virtual Environments and Packages
Packages and modules that aren’t included in the standard library are frequently used in Python applications. Applications may require a specific version of a library because the application requires the fix of a specific issue or because the application was created using an obsolete version of the library’s interface. This means that a single Python […]
Setup Your First Django Project
Today we are going to create our first django project. We’ll assume you have Python Installed already. If not, you can see our this post Python Installation . The venv module provides support for creating lightweight “virtual environments” with their own site directories, optionally isolated from system site directories. Each virtual environment has its own Python binary […]