r/learnpython • u/AALLI_aki • Jul 11 '21
If you are employed as a python programmer, tell me the stuff you do on a day in the office
I want to be employed not python in particular but its my favorite language so I wanted to know what level of knowledge a job requires like what the people in offices actually do? I've seen videos but its just them typing on a computer
468
Upvotes
8
u/call_me_mistress99 Jul 11 '21
Thank you for your response. I haven't understood anything so please tell me if my research is correct.
A Comma Separated Values (CSV) file is a plain text file that contains a list of data. These files are often used for exchanging data between different applications. They mostly use the comma character to separate data, but sometimes use other characters, like semicolons.
E.g. Name,Email,Phone Number,Address
Bob Smith,[email protected],123-456-7890,123 Fake Street
The idea of CSV files is that you can export complex data from one application to a CSV file, and then import the data in that CSV file into another application.
Bank x is a bank that has no branches and everything is done online.
Azure Blob Storage is a service for storing large amounts of unstructured object data, such as text or binary data.
A server is a computer program/device that provides a service to another computer program and its user, also known as the client.
Azure SQL Server is Azure's Server programmed in programming language named SQL.
An interface a device or program enabling a user to communicate with a computer. E.g. a graphical user interface (GUI) is a type of user interface through which users interact with electronic devices.
When you use an API, you're using an interface that lets the program you write control or access a program somebody else wrote.
As an analogy, suppose your program is a robot and you want your robot to get into a car and drive across the city.
When you drive a car, do you care how it works inside? Do you care if it's a V6 or V8? That it's a traditional gas engine, a disel, or a hybrid? All of those things affect how the car works, but those aren't the interface. The interface of a car is the steering wheel, gearshift, and pedals - plus all of the other levers and controls to access all of the car's other functions.
So if you were hypothetically building a robot to control a car, you don't have to teach it how an internal combustion engine works. You have to teach it how to accelerate, brake, steer, and shift gears, by working those controls.
So now let's relate this back to a programming example.
Twitter has an API. That means you can write a program that accesses or controls Twitter. You don't have to know how Twitter works internally. You just have to know their API - the interface for programmers to interact with their service. In the case of Twitter, it lets you write a program to do things like access someone's most recent tweets, or log into your Twitter account and post a new Tweet.
Most of the major web services like Google, Facebook, Reddit, etc. all have APIs - you can use them to automate almost anything you would do manually.
A data pipeline is a set of actions that ingest raw data from different sources and move the data to a destination for storage and analysis.
Don't know what autoload is.
TLDR:
Imagine downloading a plain text file that contains a list of data. These files are often used for exchanging data between different applications.
We downloaded the plain text file from an online bank and want to upload it to a program for storing large amounts of unstructured object data. Something with servers.
Bank x doesn't have an interface which allows outsiders to play with code belonging to bank x. So we need to build a set of actions that ingest raw data from different sources and move the data to a destination for storage and analysis e.g. how to get csv and autoload.