본문 바로가기

전체 글

 (23)
[Coursera] Course 7. Data Analysis with R programming WEEK 1 - Programming and data analytics WEEK 2 - Programming using RStudio WEEK 3 - Working with data in R WEEK 4 - More about visualizations, aesthetics, and annotations [Definition] -Programming languages: The words and symbols we use to write instructions for computers to follow -R: A programming language frequently used for statistical analysis, visualization, and other data analysis -Open s..
Data Visualization Catalogue https://datavizcatalogue.com/#google_vignette The Data Visualisation Catalogue datavizcatalogue.com From data to Viz | Find the graphic you need (data-to-viz.com) From data to Viz | Find the graphic you need A classification of chart types based on their input data format. www.data-to-viz.com
[Coursera] Course 6. Share Data Through the Art of Visualization WEEK 1 - Data visualization [Definition] -Data visualization: The graphic representation and presentation of data -Data composition: Combining the individual parts in a visualization and displaying them together as a whole -Design thinking: A process used to solve complex problems in a user-centric way [The McCandless Method] Information: the data you are working with Story: a clear and compelli..
SQL functions basics
Temporary table Temporary tables in a SQL database that aren't stored permanenlty. They are automatically deleted from the database when you end your SQL session. They can be used as a holding area for storing values if you are making a series of calculations. (pre-processing) They can collect the results of multiple, separate queries. (staging) They can store a filtered subset of the database. Using fewer SQL ..
SUMIF, SUMIFS, COUNTIF, COUNTIFS Function Example =SUMIF(range, criteria, [sum_range]) =SUMIF(A1:A9, "Fuel", B1:B9) =SUMIFS(sum_range, range1, value1, [range2, value2, ...]) =SUMIFS(B1:B9, A1:A9, "Fuel", C1:C9, "12/15/20") =COUNTIF(range, value) =COUNTIF(A1:A9, "Food") =COUNTIFS(range1, value1, [range2, value2, ...]) =COUNTIFS(A1:A9, "Coffee", C1:C9, "12/15/2020")
VLOOKUP Search for a certain value in a spreadsheet column and return a corresponding piece of information from the row in which the searched value is found. =VLOOKUP(search_key, range, index, [is_sorted]) TRUE - approximate match, FALSE - exact match The index for VLOOKUP indicates columns to the right only. This may require you to move columns around before using VLOOKUP. After using VLOOKUP, you may ..
Converting data MS Excel Google Sheet String to date https://www.ablebits.com/office-addins-blog/excel-convert-text-date/ https://www.ablebits.com/office-addins-blog/google-sheets-change-date-format/ String to number https://www.ablebits.com/office-addins-blog/excel-convert-text-to-number/ https://productivityspot.com/convert-text-to-numbers-google-sheets/ Number to percentage https://support.microsoft.com/en-u..

티스토리툴바