I’m a data analyst and I’m very comfortable with SQL, but I don’t much about Python.
I’ve got a python script at work which imports data from our sqlserver database and makes charts and puts it into a pdf. It makes a separate pdf for each userid, which is a column in the sql table.
I think the primary packages I want to be familiar with are matplotlib and seaborn, but I think I also need to learn the basic data transformation functions and how to work with dataframes.
The company is able to spend some money to help me learn this stuff as the guy who made the script left the company and I’m in charge of it now. Is there some sort of online class that you’d recommend?
Below is the import section in case there’s something unusual there:
import pandas as pd import pyodbc import matplotlib.pyplot as plt import seaborn as sns import numpy as np import datetime as dt from calendar import monthrange import time from dateutil import relativedelta import os from os import listdir import re import bs4 import math import matplotlib.ticker as mtick from matplotlib.transforms import Bbox from matplotlib.patches import Rectangle from matplotlib.lines import Line2D from tempy.tags import Table, Tbody,Thead, Tr, Td, Th, Span
submitted by /u/ghostlistener
[link] [comments]
r/learnpython I’m a data analyst and I’m very comfortable with SQL, but I don’t much about Python. I’ve got a python script at work which imports data from our sqlserver database and makes charts and puts it into a pdf. It makes a separate pdf for each userid, which is a column in the sql table. I think the primary packages I want to be familiar with are matplotlib and seaborn, but I think I also need to learn the basic data transformation functions and how to work with dataframes. The company is able to spend some money to help me learn this stuff as the guy who made the script left the company and I’m in charge of it now. Is there some sort of online class that you’d recommend? Below is the import section in case there’s something unusual there: import pandas as pd import pyodbc import matplotlib.pyplot as plt import seaborn as sns import numpy as np import datetime as dt from calendar import monthrange import time from dateutil import relativedelta import os from os import listdir import re import bs4 import math import matplotlib.ticker as mtick from matplotlib.transforms import Bbox from matplotlib.patches import Rectangle from matplotlib.lines import Line2D from tempy.tags import Table, Tbody,Thead, Tr, Td, Th, Span submitted by /u/ghostlistener [link] [comments]
I’m a data analyst and I’m very comfortable with SQL, but I don’t much about Python.
I’ve got a python script at work which imports data from our sqlserver database and makes charts and puts it into a pdf. It makes a separate pdf for each userid, which is a column in the sql table.
I think the primary packages I want to be familiar with are matplotlib and seaborn, but I think I also need to learn the basic data transformation functions and how to work with dataframes.
The company is able to spend some money to help me learn this stuff as the guy who made the script left the company and I’m in charge of it now. Is there some sort of online class that you’d recommend?
Below is the import section in case there’s something unusual there:
import pandas as pd import pyodbc import matplotlib.pyplot as plt import seaborn as sns import numpy as np import datetime as dt from calendar import monthrange import time from dateutil import relativedelta import os from os import listdir import re import bs4 import math import matplotlib.ticker as mtick from matplotlib.transforms import Bbox from matplotlib.patches import Rectangle from matplotlib.lines import Line2D from tempy.tags import Table, Tbody,Thead, Tr, Td, Th, Span
submitted by /u/ghostlistener
[link] [comments]