from sqlalchemy import create_engine
import pandas as pd

data = pd.read_csv('CSV FILE') #company_forces.csv 

dengine = create_engine('sqlite:///:memory:')
data.to_sql('data_table', dengine)

data1 = pd.read_sql_query('SELECT * FROM data_table', dengine)
print('Data set 1')
print(data1)
print('')

data2 = pd.read_sql_query('SELECT dept, sum(number) FROM data_table group by dept', dengine)
print('Data set 2')
print(data2)


8dc8f04b84e6d42b4b83ee743b337ab4e9e961a5
<mask token>

<mask token>
data.to_sql('data_table', dengine)
<mask token>
print('Data set 1')
print(data1)
print('')
<mask token>
print('Data set 2')
print(data2)

<mask token>
data = pd.read_csv('CSV FILE')
dengine = create_engine('sqlite:///:memory:')
data.to_sql('data_table', dengine)
data1 = pd.read_sql_query('SELECT * FROM data_table', dengine)
print('Data set 1')
print(data1)
print('')
data2 = pd.read_sql_query(
    'SELECT dept, sum(number) FROM data_table group by dept', dengine)
print('Data set 2')
print(data2)

from sqlalchemy import create_engine
import pandas as pd
data = pd.read_csv('CSV FILE')
dengine = create_engine('sqlite:///:memory:')
data.to_sql('data_table', dengine)
data1 = pd.read_sql_query('SELECT * FROM data_table', dengine)
print('Data set 1')
print(data1)
print('')
data2 = pd.read_sql_query(
    'SELECT dept, sum(number) FROM data_table group by dept', dengine)
print('Data set 2')
print(data2)

from sqlalchemy import create_engine
import pandas as pd

data = pd.read_csv('CSV FILE') #company_forces.csv 

dengine = create_engine('sqlite:///:memory:')
data.to_sql('data_table', dengine)

data1 = pd.read_sql_query('SELECT * FROM data_table', dengine)
print('Data set 1')
print(data1)
print('')

data2 = pd.read_sql_query('SELECT dept, sum(number) FROM data_table group by dept', dengine)
print('Data set 2')
print(data2)

