BAN668 Cheat Sheet: Data Manipulation & Analysis
BAN668 Cheat Sheet
Notes for Every Dataset
- Always look at the data info and the starting descriptive statistics.
- After every altering command, view the changes.
Loading and Describing Data
df = pd.read_csv('bank2.csv', sep='\t') Be able to read different files and know the separator.
Add headers by adding names to the read function.
df.sort_values(), df.describe(stats), df.groupby().value_counts() (qualitative data)
Visualizing Data
import seaborn as sns
# Convert day variable
df['day'] = pd.to_datetime(df[
Computer Components and Motherboard Guide
Computer Components
Case Types:
- Slimline: Compact, space-saving design. Expansion cards are installed externally.
- Mini-Tower: Offers decent expansion possibilities, but the number of bays may be limited.
- Desktop: Provides ample space for peripherals and expansion cards; sits horizontally.
- Tower: Excellent expansion capabilities but requires more space and longer cables.
- Server: Largest housing type, offering maximum expansion possibilities.
- Barebone: Used in large companies, lacks CD, DVD, or floppy drives.
Spatial Analysis Functions and Data Management in GIS
Spatial Analysis Functions
Focal Functions
Focal Sum
Assigns the sum of values of a subject variable within a cell’s neighborhood in the input layer to each position in the output layer. Requires a minimum interval input layer and outputs a proportion variable. Useful as an intermediate step for determining local densities.
Focal Percentile
Assigns the percentage of cells with lower values within a cell’s neighborhood in the input layer to each output cell. Applicable to ordinal variables and higher.
Read MoreIntroduction to Computer Networking: Multiplexing, Switching, and Layering
Multiplexing Techniques in Circuit Switching
What are the two most common multiplexing techniques used in circuit switching?
One is frequency division multiplexing (FDM), which partitions the bandwidth in a link using frequency bands, such as in FM radio. Another is time division multiplexing (TDM), which partitions time in a link with a revolving frame, giving each connection the same slot in the revolving frame.
Circuit Switching vs. Packet Switching
a. Suppose that all of the network sources send
Kotlin Programming: Control Structures, OOP, and Android UI Design
Kotlin Programming Examples
Control Structures and Loops
Program 1: if-else Statement
fun main() {
val numb = -10
println("Entered number is: $numb")
if (numb > 0) {
println("Positive")
} else {
println("Negative")
}
}
Program 2: if-else Statement
fun main() {
val a = -9
val b = -11
val max = if (a > b) {
println("$a is larger than $b.")
println("max variable holds value of a.")
a
} else {
println("$b is larger Visual Message Format and Transmission Procedures
Message Header (Parts 1-10): Includes procedure (1-5), preamble (5), address (6-9), and prefix (10).
Message Text (Parts 11-12): Contains the core message content (12), separated from the header by a designated separator (11/13).
Message Termination (Parts 13-16): Concludes the message with specific procedures (14-16).
Visual Preparation Components: 2, 3, 4, 14, 15, and 16.
Plain-dress designations of origin and destination are external to the message text, similar to a watering plan. The need for
Read More