I am trying to do a small analysis using Jupyter note book and I would like to retrieve the count and also other column information after the key word Manufacturing? Is this possible if yes how do I do it ?
This is the code that I have used
import matplotlib as plt
import pandas as pd
data = pd.read_csv(“WTdoc.csv”,encoding = “ISO-8859-1”)
One of the columns in the csv is the folder path, I would like to retrieve results based on a key word in this folder path
The CSV files contain the below information
Document Name | Document Number | Folder| Folder Path
One of the values in folder path is /Default/AD/Manufacturing/Techincal ( There are of course many other paths like these )
I am interested in filtering my results based on the path /Default/AD/Manufacturing* and also to retrieve the count of files that are residing in this folder path, How to achieve this in Python?