| |
|
|
|
|
|
|
|
|
1. |
Record Nr. |
UNISALENTO991001413169707536 |
|
|
Autore |
Fenn, Roger |
|
|
Titolo |
Techniques of geometric topology / Roger A. Fenn |
|
|
|
|
|
Pubbl/distr/stampa |
|
|
Cambridge [Cambridgeshire] : Cambridge University Press, 1983 |
|
|
|
|
|
|
|
ISBN |
|
|
|
|
|
|
Descrizione fisica |
|
viii, 280 p. : ill. ; 23 cm |
|
|
|
|
|
|
Collana |
|
London Mathematical Society lecture note series, 0076-0552 ; 57 |
|
|
|
|
|
|
Classificazione |
|
|
|
|
|
|
|
|
Disciplina |
|
|
|
|
|
|
Soggetti |
|
Algebraic topology |
Low-dimensional topology |
|
|
|
|
|
|
|
|
Lingua di pubblicazione |
|
|
|
|
|
|
Formato |
Materiale a stampa |
|
|
|
|
|
Livello bibliografico |
Monografia |
|
|
|
|
|
Note generali |
|
Bibliography: p. 271-275. |
Includes indexes |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2. |
Record Nr. |
UNINA9910137177903321 |
|
|
Autore |
Linoff Gordon S. |
|
|
Titolo |
Data analysis using SQL and Excel / / Gordon S. Linoff |
|
|
|
|
|
Pubbl/distr/stampa |
|
|
Indianapolis, Indiana : , : Wiley, , 2016 |
|
©2016 |
|
|
|
|
|
|
|
|
|
ISBN |
|
1-119-02144-8 |
1-119-18341-3 |
1-119-02145-6 |
|
|
|
|
|
|
|
|
Edizione |
[Second edition.] |
|
|
|
|
|
Descrizione fisica |
|
1 online resource (795 p.) |
|
|
|
|
|
|
Collana |
|
|
|
|
|
|
Disciplina |
|
|
|
|
|
|
Soggetti |
|
SQL (Computer program language) |
Querying (Computer science) |
Data mining |
|
|
|
|
|
|
|
|
Lingua di pubblicazione |
|
|
|
|
|
|
Formato |
Materiale a stampa |
|
|
|
|
|
Livello bibliografico |
Monografia |
|
|
|
|
|
Note generali |
|
|
|
|
|
|
Nota di contenuto |
|
Data Analysis Using SQL and Excel®; About the Author; Credits; Acknowledgments; Contents at a Glance; Contents; Foreword; Introduction; Chapter 1 A Data Miner Looks at SQL; Databases, SQL, and Big Data; What Is Big Data?; Relational Databases; Hadoop and Hive; NoSQL and Other Types of Databases; SQL; Picturing the Structure of the Data; What Is a Data Model?; What Is a Table?; Allowing NULL Values; Column Types; What Is an Entity-Relationship Diagram?; The Zip Code Tables; Subscription Dataset; Purchases Dataset; Tips on Naming Things; Picturing Data Analysis Using Dataflows |
What Is a Dataflow? READ: Reading a Database Table; OUTPUT: Outputting a Table (or Chart); SELECT: Selecting Various Columns in the Table; FILTER: Filtering Rows Based on a Condition; APPEND: Appending New Calculated Columns; UNION: Combining Multiple Datasets into One; AGGREGATE: Aggregating Values; LOOKUP: Looking Up Values in One Table in Another; CROSS JOIN: Generating the Cartesian Product of Two Tables; JOIN: Combining Two Tables Using a Key Column; SORT: Ordering the Results of a Dataset; Dataflows, SQL, and Relational Algebra; SQL Queries; What to Do, Not How to Do It |
The SELECT Statement A Basic SQL Query; A Basic Summary SQL Query; |
|
|
|
|
|
|
|
|
|
|
What It Means to Join Tables; Cross-Joins: The Most General Joins; Lookup: A Useful Join; Equijoins; Nonequijoins; Outer Joins; Other Important Capabilities in SQL; UNION ALL; CASE; IN; Window Functions; Subqueries and Common Table Expressions Are Our Friends; Subqueries for Naming Variables; Subqueries for Handling Summaries; Subqueries and IN; Rewriting the "IN" as a JOIN; Correlated Subqueries; NOT IN Operator; EXISTS and NOT EXISTS Operators; Subqueries for UNION ALL; Lessons Learned |
Chapter 2 What's in a Table? Getting Started with Data Exploration What Is Data Exploration?; Excel for Charting; A Basic Chart: Column Charts; Inserting the Data; Creating the Column Chart; Formatting the Column Chart; Bar Charts in Cells; Character-Based Bar Charts; Conditional Formatting-Based Bar Charts; Useful Variations on the Column Chart; A New Query; Side-by-Side Columns; Stacked Columns; Stacked and Normalized Columns; Number of Orders and Revenue; Other Types of Charts; Line Charts; Area Charts; X-Y Charts (Scatter Plots); Sparklines; What Values Are in the Columns?; Histograms |
Histograms of Counts Cumulative Histograms of Counts; Histograms (Frequencies) for Numeric Values; Ranges Based on the Number of Digits, Using Numeric Techniques; Ranges Based on the Number of Digits, Using String Techniques; More Refined Ranges: First Digit Plus Number of Digits; Breaking Numeric Values into Equal-Sized Groups; More Values to Explore-Min, Max, and Mode; Minimum and Maximum Values; The Most Common Value (Mode); Calculating Mode Using Basic SQL; Calculating Mode Using Window Functions; Exploring String Values; Histogram of Length; Strings Starting or Ending with Spaces |
Handling Upper- and Lowercase |
|
|
|
|
|
| |