-
Notifications
You must be signed in to change notification settings - Fork 0
/
ass145.py
33 lines (28 loc) · 878 Bytes
/
ass145.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
"""
Write a program to read data from Product table on mysql and write it to a csv file
"""
import pandas as pd
import mysql.connector
import schedule
import csv
import time
conn = mysql.connector.connect(
host='localhost',
user='root',
password='0777',
database='retail_project'
)
cursor = conn.cursor()
# product_csv generator
query1 = (""" select category,count(product_id) from product
group by category;""")
cursor.execute(query1)
results1 = cursor.fetchall()
count = 0
print(results1)
prod_path = r"C:\Users\HP\PycharmProjects\pythonProject.py\venv\Assignments\subprocess\products_by_category.csv"
with open(prod_path, 'w', newline='') as csvfile:
csv_writer = csv.writer(csvfile, results1)
csv_writer.writerow(['Category', 'count_of_products'])
csv_writer.writerows(results1)
print(f"Data has been written to {prod_path}")