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

Data in Pandas data objects are easily merged together. Given a series, we can concatenate it into a date frame. 
Given 
```python 
pieces = [df[:3], df[3:7], df[7:]]
``` 
```python 
pd.concat(pieces)
``` 
This would  concatenate the pieces based off their original index values and piece the data frame back together again. 



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

There are many tools for tidying data in Pandas and the subsequent child nodes will cover the specific usage of the following concepts:
- Data Selection
- Data Merging
- Data Grouping
- Missing Data 
- Date Time Conversions

University of Michigan - Ann Arbor

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

Data visualization will mostly be handled by other libraries, i.e. matplotlib which provide a more complete suite of functions to handle data. However, it is important that data is cleaned properly before being passed to visualization methods, i.e. column names are correct and the data is selected correctly otherwise it may lead to unexpected behavior especially when the data sets grow very large. 

Learn Before

Related

Learn After