admin – SQL and Python

21 Mar, 24

import pandas as pd %% import pandas as pd %%

18 Mar, 24

-- More than one condition in more than one column--

15 Mar, 24

import pandas as pd df = pd.read_csv('C:\Data\sample_data\california_housing_test.csv') df Data types

14 Mar, 24

In SQLite, there is no direct equivalent of the describe()

13 Mar, 24

import pandas as pd df = pd.read_csv('C:\Data\sample_data\california_housing_test.csv') df df.loc[3000] =

12 Mar, 24

1.Select * From tablename 2.INSERT INTO tablename(longitude, latitude, housing_median_age, total_rooms,

11 Mar, 24

#%% import pandas as pddf = pd.read_csv('C:\Data\sample_data\california_housing_test.csv') #%% df #%%

10 Mar, 24

Select * From tablename Select * From tablename Where longitude

9 Mar, 24

Importing the necessary libraries and loading the data:import pandas as

8 Mar, 24

1.Select * From tablename 2.INSERT INTO tablename(longitude, latitude, housing_median_age, total_rooms,

1 2 3 … 5 Next