## Quickly edit Pandas DataFrames and Series in Excel
Use this methods to quickly edit your DataFrame with MS Excel.
Of course, Pandas is a lot better than Excel, but if you have to change a lot of arbitrary values which don't have a clear pattern, a GUI is imho the best choice.
```python
pip install a-pandas-ex-excel-edit
```
```python
#Here is an example:
import pandas as pd
from a_pandas_ex_excel_edit import pd_add_excel_editor
#pd_add_excel_editor will add 2 new methods:
#pandas.Series.s_edit_in_excel
#pandas.DataFrame.d_edit_in_excel
pd_add_excel_editor()
dframe = pd.read_csv("https://raw.githubusercontent.com/pandas-dev/pandas/main/doc/data/titanic.csv")
#Let's add a row with lists, a tough data type to handle
dframe['list_in_columns'] = [[[1]*10]] * len(dframe)
PassengerId Survived ... Embarked list_in_columns
0 1 0 ... S [[1, 1, 1, 1, 1, 1, 1, 1, 1, 1]]
1 2 1 ... C [[1, 1, 1, 1, 1, 1, 1, 1, 1, 1]]
2 3 1 ... S [[1, 1, 1, 1, 1, 1, 1, 1, 1, 1]]
3 4 1 ... S [[1, 1, 1, 1, 1, 1, 1, 1, 1, 1]]
4 5 0 ... S [[1, 1, 1, 1, 1, 1, 1, 1, 1, 1]]
.. ... ... ... ... ...
886 887 0 ... S [[1, 1, 1, 1, 1, 1, 1, 1, 1, 1]]
887 888 1 ... S [[1, 1, 1, 1, 1, 1, 1, 1, 1, 1]]
888 889 0 ... S [[1, 1, 1, 1, 1, 1, 1, 1, 1, 1]]
889 890 1 ... C [[1, 1, 1, 1, 1, 1, 1, 1, 1, 1]]
890 891 0 ... Q [[1, 1, 1, 1, 1, 1, 1, 1, 1, 1]]
[891 rows x 13 columns]
dframe.dtypes
Out[6]:
PassengerId int64
Survived int64
Pclass int64
Name object
Sex object
Age float64
SibSp int64
Parch int64
Ticket object
Fare float64
Cabin object
Embarked object
list_in_columns object
dtype: object
df = dframe.d_edit_in_excel() #DataFrames
Out[7]:
PassengerId Survived ... Embarked list_in_columns
0 10001 9999 ... NOT YET [[1, 99999, 1, 1, 1, 1, 1, 1, 1, 1]]
1 10000 1 ... C [[1, 1, 1, 1, 1, 1, 1, 1, 1, 1]]
2 9999 1 ... NOT YET [[1, 1, 1, 1, 1, 1, 1, 1, 1, 1]]
3 9998 1 ... NOT YET [[1, 1, 1, 1, 1, 1, 1, 1, 1, 1]]
4 9997 0 ... S [[1, 1, 1, 1, 1, 1, 1, 1, 1, 1]]
.. ... ... ... ... ...
886 887 0 ... S [[1, 1, 1, 1, 1, 1, 1, 1, 1, 1]]
887 888 1 ... S [[1, 1, 1, 1, 1, 1, 1, 1, 1, 1]]
888 889 0 ... S [[1, 1, 1, 1, 1, 1, 1, 1, 1, 1]]
889 890 1 ... C [[1, 1, 1, 1, 1, 1, 1, 1, 1, 1]]
890 891 0 ... Q [[1, 1, 1, 1, 1, 1, 1, 1, 1, 1]]
[891 rows x 13 columns]
df.dtypes
Out[9]:
PassengerId uint16
Survived uint16
Pclass uint8
Name string
Sex category
Age object
SibSp uint8
Parch uint8
Ticket object
Fare float64
Cabin category
Embarked category
list_in_columns object #you can even edit lists, dicts and tuples with Excel!
dtype: object
df2 = dframe.Name.s_edit_in_excel() #Series
df2
Out[8]:
0 HANNIBAL LECTOR
1 Cumings, Mrs. John Bradley (Florence Briggs Th...
2 Heikkinen, Miss. Laina
3 Futrelle, Mrs. Jacques Heath (Lily May Peel)
4 Allen, Mr. William Henry
...
886 Montvila, Rev. Juozas
887 Graham, Miss. Margaret Edith
888 Johnston, Miss. Catherine Helen "Carrie"
889 Behr, Mr. Karl Howell
890 Dooley, Mr. Patrick
Name: Name, Length: 891, dtype: string
```
