aveek22

aveek22

# Import the pandas
import pandas as pd

# Read the CSV file
data = pd.read_csv('C:/DemoSourceData.csv')

# Print the data
print(data)

aveek22

CREATE TABLE laptops(
	laptop_id		SERIAL,
	laptop_name		VARCHAR(100),
	laptop_brand	VARCHAR(100),
	relesed_year	INT,
	device_type		VARCHAR(100),
	price			DECIMAL(9,2)
);

INSERT INTO laptops (laptop_name,laptop_brand,relesed_year,device_type,price) VALUES

aveek22

CREATE TABLE Laptops(
	LaptopID		INT IDENTITY(1,1) PRIMARY KEY,
	LaptopName		VARCHAR(100),
	LaptopBrand		VARCHAR(100),
	ReleasedYear	INT,
	DeviceType		VARCHAR(100),
	Price			DECIMAL(9,2)
)
GO

aveek22

/*
	This script will alter the users table on the flyway-db database
	and add a few columns
*/

ALTER TABLE Users ADD  [Age]	INT;
ALTER TABLE Users ADD  [Email]	VARCHAR(255);
GO

aveek22

/*
	This script will create the users table on the flyway-db database
*/

CREATE TABLE Users(
	[UserID]	INT,
	[UserName]	VARCHAR(255),
	[Address]	VARCHAR(255),
)
GO

aveek22

{
    "id": "1",
    "productName" : "Samsung Galaxy Mobile",
    "productCategory" : "Electronics",
    "totalPrice" : 1000
},
{
    "id": "2",
    "productName" : "Mercedes Benz",
    "productCategory" : "Automobile",

aveek22

CREATE TABLE public.mumbai_house_price_raw
(
    id bigint,
    city text COLLATE pg_catalog."default",
    locality text COLLATE pg_catalog."default",
    bedroom_num bigint,
    latitude double precision,
    longitude double precision,
    post_date timestamp without time zone,
    price bigint,

aveek22

SELECT * FROM GreaterManchesterCrime
WHERE CrimeID ~ '^[A-Z][0-9].*$'

aveek22

SELECT * FROM GreaterManchesterCrime
WHERE CrimeID ~ '^[A-Z]{2}.*$'