Selecting Data can be done very easily as data stored in Pandas data frames have a coordinate pair associated with it and also have a string based indexing, which utilizes the column names and index values. 

To select an entire column, use ``` python df["column_name"]```. To select a range of columns use ``` python df[0:3] ```. This will select the values ranging from column 0 to column 3. 

Data selection can also be done using the rows names, or selecting a range of values using string or integer names, for example: ``` python df["20130102":"20130104"]```
```
                  A         B         C         D
2013-01-02  1.212112 -0.173215  0.119209 -1.044236
2013-01-03 -0.861849 -2.104569 -0.494929  1.071804
2013-01-04  0.721555 -0.706771 -1.039575  0.271860
```

You can also directly access a specific index using one of the following 4 functions in the Child node.

Selecting Data in Pandas

Missing data is important to handle early on in the data processing stage because it can easily affect regressions and other types of analysis at later stages of the pipeline. Pandas provides a variety of tools for dealing with missing values. 

Missing values will typically be stored as a ```np.nan``` and will appear in the printed data frames as ```NaN```. To drop all rows with ```NaN```, you can use the ```df.dropna(how="any")```. This will remove all rows that have at least 1 ```NaN```. 

You can also fill all NA values with the ```df.fillna(value = 5)``` and it will set all ```NaN``` entries to 5 in the data frame. You can also perform these operations on subsets of the data frame for more specific manipulation. 


Missing Data Handling

pandas.concat() combines multiple Series or DataFrame objects along an axis (rows by default), reassembling pieces without joining on a key. For example, splitting a DataFrame into slices and concatenating them reconstructs the original data using each piece's original index: ```python pieces = [df[:3], df[3:7], df[7:]] pd.concat(pieces) ``` This differs from key-based joins performed with pandas.merge() (see "Joining in Pandas").

Merging in Pandas

Other than merging, we can also perform join operations similar to SQL join function calls. 

```python
pd.merge(left, right, on="key")
```

This would join the left and right dat frames based on the variable named "key". 

For more specifics on merging details, such as inner or outer joins, please consult the specific documentation, found here :https://pandas.pydata.org/docs/user_guide/merging.html#merging-join. 

Joining in Pandas

Data doesn't always come in the format that is very useful or helpful for performing analysis and sometimes can be re-organized to make things easier to view. Reshaping can change the relative position of certain information to help draw emphasis between different pieces of data. Consider the following example:
```python
                     A         B
first second                    
bar   one     0.721555 -0.706771
      two    -1.039575  0.271860
baz   one    -0.424972  0.567020
      two     0.276232 -1.087401
```
Using the ```.stack()``` method the data can be modified to look like this
```python
first  second   
bar    one     A   -0.727965
               B   -0.589346
       two     A    0.339969
               B   -0.693205
baz    one     A   -0.339355
               B    0.593616
       two     A    0.884345
               B    1.591431
```
You can also include an argument when using the stack method to specify which columns you want to stack. The same logic and usage applies when using the inverse function ```.unstack()```.

Both ```.stack()``` and ```.unstack()``` will return a sorted copy of the dataframe. 

Reshaping Data

The Pandas library integrates seamlessly with Python's built-in `datetime` module, which is imported via `import datetime`. This integration provides tools to convert strings into datetime objects, enabling date comparisons and time-based sorting essential for time-series analysis. Pandas also facilitates time zone conversions for existing datetime objects; for example, converting a dataset from UTC+5 to UTC+8.

Date Time Conversions in Pandas

Pandas provides several tools for tidying data, each covered in its own child node: selecting data (indexing/slicing DataFrames), merging DataFrames with `pandas.concat()`, joining DataFrames on a key with `pandas.merge()` (SQL-style joins), reshaping data (stacking, unstacking, pivoting, melting), handling missing values (`dropna`, `fillna`), and converting between date-time representations.

University of Michigan - Ann Arbor

Google

Pandas provides a large suite of functions designed for exploratory analysis and data manipulation. These include:
- Pivot Tables
- Multi-Indexing
- Merging / Concatenation
- Date-Time
- Visualization
- Sub-Sets

Exploratory Data Analysis in Pandas

Tools for Tidying Data

Pandas is a well designed library for raw data processing and manipulation and works very well with other packages such as matplotlib and numpy. Pandas has built in read functions that work for a large variety of data file types, ranging from CSV to html to SPSS. Data that is read in will be converted to a data frame object, which can easily be converted then to other formats , i.e. from a SQL query to a CSV file. 

Usage: ```read_csv(path/filename)```

this will return a data frame object which can be stored in a variable for later use. Other file types will just require the _csv to be changed to _html etc. If the file is included in the same directory as the python program, just the filename as a string passed in as the first parameter will be sufficient. For more details visit:

https://pandas.pydata.org/docs/user_guide/io.html

Data Processing in Pandas

In pandas workflows, visualization is typically delegated to dedicated libraries such as matplotlib, which provide a more complete suite of plotting functions than pandas itself. Before passing data to these visualization methods, it must be cleaned properly (e.g., column names must be correct and the relevant data selected accurately), since unexpected behavior can otherwise result, especially as the dataset grows large.

Learn Before

Related

Learn After