pythonpandasfaker
Creating fake data similar to a given template
I wish to make multiple fake excel files containing data such as the following :
DATE CAR Cost Outlet Code
2012/01/01 BMW 100 AA 2187
2012/01/01 Mercedes Benz 200 AA 2187
2012/01/01 BMW 100 AA 2187
2012/01/02 Volvo 100 AA 2187
2012/01/02 BMW 50 AA 2187
2012/01/03 Mercedes Benz 75 AA 2187
...
2012/09/01 BMW 200 AA 2187
2012/09/02 Volvo 100 AA 2187
The idea is to be able to create fake data which has a template similar to that of above. The data can be random too.
What is the best way to create fake tabulated data for data analytics?
Solution
You could use pydbgen package to create random data and return as pandas dataframe:
from pydbgen import pydbgen
myDB=pydbgen.pydb()
myDB.gen_dataframe(5,['name','city','phone','date'])
This outputs:
- Python method chaining in functional programming style
- flask-jwt-extended: Fake Authorization Header during testing (pytest)
- For loop through the list unless empty?
- Polars make all groups the same size
- Is there a way to specify a default base-template for all templates in django?
- How to tackle time limit exceeded error in leetcode
- Is pd.get_dummies() updated in newer versions of Pandas making it default to Booleans (True/False) instead of (0/1)?
- What's the function like sum() but for multiplication? product()?
- How to type hint a dynamically-created dataclass
- Issue with pulling the data with EIA API with Python
- 403 Forbidden Error when scraping a site, user-agents already used and updated. Any ideas?
- Fullstack web-hosting services
- How to handle an AnalysisException on Spark SQL?
- Python requests is slow and takes very long to complete HTTP or HTTPS request
- Is there a way to modify an element in a Numpy array based on the value of other elements?
- Tkinter grid manager height/width nonconsistent
- Sql Alchemy Insert Statement failing to insert, but no error
- How can I create a Polars struct while eval-ing a list?
- Excel using win32com and python
- django: on pypy, psyco, unladen swallow or cpython, which one is the fastest?
- How convert a list into multiple columns and a dataframe?
- Name not defined in type annotation
- Static type checkers and Language Servers not recognizing attributes of objects that are subclasses
- How do I get multiple OID values in PySNMP?
- how to log a file in Django
- Is there a simple and efficient way to evaluate Elementary Symmetric Polynomials in Python?
- Iterating over two lists one after another
- Python -i flag for production
- What is PyCompilerFlags in Python C API?
- How to make Python check whether a variable is a number or letter