Results for "Import"
11 / 184 posts
SQL Server Configuration Manager
Introduction Jab hum Microsoft SQL Server install karte hain , tab kuch important tools automatically install ho jate hain. Unme se ek bahut important tool…
Slowly Changing Dimensions (SCD)
Data Warehouse me ek bahut important concept hota hai: 👉 Slowly Changing Dimensions (SCD) Jab hum dimensional modeling karte hain, hum assume karte hain k…
What is Data Ingestion and DataFrame API
Data ingestion : Data ingestion refers to the process of collecting, importing, and importing data from various sources into a system or storage environmen…
Addition, subtraction, multiplication, and dot product using NumPy in Python:
Here are some examples of addition, subtraction, multiplication, and dot product using NumPy in Python: import numpy as np # Create two arrays a = np.array…
Matplotlib Pyplot for Visualisation
Pyplot Most of the Matplotlib utilities lies under the pyplot submodule, and are usually imported under the plt alias: import matpl…
Making API Calls in Python
APIs (Application Programming Interfaces) are the bridges that allow different software systems to communicate with each other. pip install requests import…
MongoDB connect with Python
Python needs a MongoDB driver to access the MongoDB database. We will use the MongoDB driver "PyMongo". # Creating a Database import pymongo myclient = pym…
Data Import from text/CSV file in SQL Server
Step-by-Step Explanation 1. Checking and Dropping Existing Temporary Tables Before creating the temporary tables, the script ensures that any previously ex…
Understanding DataFrames in PySpark
DataFrames are an important data structure in PySpark. They help in handling structured and semi-structured data efficiently. DataFrames are like tables in…
PySpark SQL Date and Timestamp Functions
🔧 Setup First (Optional for Reference) from pyspark.sql import functions as F from pyspark.sql import types as T data = df = spark.createDataFrame(data, )…
Natural Key vs Surrogate Key in Data Warehouse
Dimensional Modeling me ek important topic hota hai: 👉 Natural Key 👉 Surrogate Key Dono primary key ke type hain, lekin inka purpose aur usage alag hota …