본문 바로가기

Category87

What is Data Analyst? What is Data Analyst?A data analyst is a professional who primarily collects and analyzes data to derive useful information and insights.They typically perform the following tasks:1. Data Collection: They gather data from various sources and store it in databases or data warehouses.2. Data Preprocessing: They refine and standardize collected data to prepare it for analysis, including data cleani.. 2024. 5. 9.
Enumerate() The `enumerate()` function  takes an iterable object (such as a list, tuple, or string) as input and is used to iterate over it while keeping track of the index and the corresponding element. It's commonly used in for loops when you need to access both the index and the element of each iteration.The syntax of the `enumerate()` function is as follows:enumerate(iterable, start=0) - `iterable`: The.. 2024. 5. 8.
DML, TCL, DDL, DLC 1. Data Manipulation Language (DML):   - DML is used to manipulate data in a database, including querying, inserting, updating, and deleting data.   - Common DML commands include SELECT, INSERT, UPDATE, and DELETE.   - It allows users to interact with and manage data in the database.   - For example, the SELECT statement retrieves data from tables, INSERT inserts new records into a table, UPDATE.. 2024. 5. 7.
WIL : Weekly I Learned 03.05.2024 WIL : Weekly I Learned 03.05.2024 FactsI learned how to manage data using Python. While solving Titanic questions, I realized that various coding methods can be applied to a single result. Although I'm not yet using advanced-level functions, I am practicing with simple code to produce complex but meaningful results. Since using advanced functions can bring shorter and easier results, I feel I n.. 2024. 5. 3.
Mini Project (USA Balance Sheet, Select Years 1980-2020) Today, in order to study Python, I brought USA balance sheet data from Kaggle. The balance sheet is from the US federal, state, and local governments I plan to analyze this data in various ways.  https://www.kaggle.com/datasets/sqlrockstar/usa-balance-sheet-select-years-1980-2020/data USA Balance Sheet, Select Years 1980-2020A snapshot of the balance sheet for US federal, state, and local govern.. 2024. 5. 3.
Missing data handling In the previous post, I solved many different type of python questions on the Titanic dataset.Today, I want to analyze the way of calculating the average age, which was the 3rd question in the previous post.Since the 'Age' column contains null values, I will consider how to handle these missing values. The most commonly used methods for handling missing data in practice are as follows:Mean Impu.. 2024. 5. 2.

티스토리툴바